Definition and Usage
Use this command to insert one or more blank rows at a specific position in a Lark Sheets worksheet. You choose a reference row, then insert the new rows either above or below it. Indexing for the reference row starts at 1.
Parameter Values
IInput Parameters
Parameter Name | Description | Possible Values | Required | Options / Notes |
Lark Sheets | Target Lark Sheets object where rows will be inserted. | Lark Sheets object | Yes | Ensure the sheet is accessible and loaded; select the correct sheet tab if the object contains multiple sheets. |
Direction | Position of new rows relative to the reference row. | below, above | Yes | Choose ‘above’ to insert before the reference row; choose ‘below’ to insert after it. |
Reference row | The row index used as the insertion anchor (1-based). | Positive integer | Yes | Must be within existing row range; 1 refers to the first row. |
Row count | Number of blank rows to insert. | Positive integer | Yes | Large counts may shift data significantly; verify downstream references. |
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’s fields. For example, you might compute the reference row or row count in a prior step and use those values here. If the UI marks fields with {x}, that indicates the field supports variables. Use variables to adapt insertion position and count at runtime based on data or logic from your workflow.
Notes
Ensure the Lark Sheets object is valid and points to the intended worksheet before insertion.
Reference row is 1-based; confirm the row exists to avoid errors.
Inserting rows shifts existing data down; review formulas, ranges, and downstream steps that depend on row positions.
Use conservative row counts when working with large sheets to minimize performance impact.
Combine with prior validation (e.g., checking last used row) to avoid inserting beyond sheet bounds.