Definition and Usage
Use this action to insert one or more blank columns at a specific position in a Lark Sheets worksheet. You choose a reference column and whether to insert the new columns to its left or right. Column indexes can be provided as numbers (starting from 1) or as letters (e.g., A, B, C).
Parameter Values
Input Parameters
Parameter Name | Description | Possible Values | Required | Options / Notes |
Lark Sheets | Select the target Lark Sheets object. | Existing Lark Sheets object | Yes | Ensure the sheet is accessible and you have edit permissions; the target sheet must exist. |
Direction | Where to insert relative to the reference column. | right, left | Yes | Choose right to add after the reference; left to add before it. |
Reference column | The column to anchor insertion; accepts index or letter. | Positive integer starting from 1; column letter (A, B, C, ...) | Yes | Use 1 or A for the first column; ensure the reference exists in the sheet. |
Column count | Number of blank columns to insert. | Positive integer | Yes | Must be ≥1; large values shift existing columns accordingly. |
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 earlier steps into this command. For example, you might compute the reference column or column count in a prior step and use those values here. If the UI marks a field with {x}, it indicates the field supports variables. Use variables to adapt the direction, reference column, or count based on runtime logic or prior data.
Notes
Confirm the Lark Sheets object points to the correct workbook and worksheet before running.
The reference column must exist; inserting relative to a non-existent column will fail.
Column letters are case-insensitive; both A and a are valid.
Inserting many columns can shift existing data; verify formulas and ranges afterward.
Use a positive integer for Column count; zero or negative values are invalid.
Permissions: you need edit permissions to modify the sheet.