Definition and Usage
Delete a specified column in a Lark spreadsheet. Use this command to remove a column by its index. Column indexing supports numbers starting from 1 or letter notation starting from A.
Parameter Values
Input Parameters
Parameter Name | Description | Possible Values | Required | Options / Notes |
Lark Sheets | The target Lark spreadsheet object to modify. | A previously created/selected Lark Sheets object | Yes | Ensure the Lark Sheets object exists and is connected; the sheet must be accessible and you must have edit permission. |
Column index | The column to delete by index. | Numeric index starting at 1; or letters starting at A | Yes | Use 1 or A for the first column; confirm the column exists to avoid errors; deleting a column shifts columns to the left. |
Advanced Settings
No advanced settings available.
Error Handling
Parameter Name | Description |
Throw error & stop | When an error occurs, the action will stop execution. |
Retry command | The action retries the command if an error occurs. |
Ignore error & continue | The action ignores the error and continues workflow execution. |
Variables Produced
This action doesn't produce any variables.
Using Variables in Conditions
You can pass dynamic values from previous steps into this command. For example, supply the Lark Sheets object created earlier or compute the column index in prior steps and reference it here. If the UI marks a field with {x}, it indicates that the field supports variables, allowing you to inject values resolved at runtime.
Notes
Ensure the target Lark spreadsheet is available and you have permission to edit it.
Verify the column index (number or letter) corresponds to an existing column to prevent failures.
Deleting a column is irreversible in the step; consider backing up data or confirming logic before execution.
After deletion, columns to the right shift left by one; update any subsequent steps that reference column positions.
If the sheet contains protected ranges or locked columns, deletion may fail depending on permissions.