Skip to main content

Delete row from Lark Sheets

Sophie avatar
Written by Sophie
Updated this week

Definition and Usage

Delete row from Lark Sheets removes a specific row from a Lark spreadsheet. Provide the target Lark Sheets object and the row index (starting at 1) to delete.

Parameter Values

Input Parameters

Parameter Name

Description

Possible Values

Required

Options / Notes

Lark Sheets

The spreadsheet object where the row will be deleted.

A valid Lark Sheets object

Yes

Ensure the object is created or opened earlier in the workflow; must point to the correct sheet/document.

Row index

The position of the row to delete; counting starts at 1.

Positive integer ≥ 1

Yes

Verify the row exists; deleting shifts subsequent rows up; avoid using 0-based indexes.

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 into this command using variables from previous steps. For example, supply a row index captured earlier to decide which row to delete at runtime. If the UI marks a field with {x}, it indicates the field accepts variables. Use variables to adapt to changing sheet targets or row positions without hardcoding values.

Notes

  • Ensure the Lark Sheets object is valid and accessible (permissions, network connectivity).

  • Confirm the row index exists to avoid errors; indexes start at 1.

  • Deleting a row reindexes subsequent rows; plan loops and subsequent row references accordingly.

  • If the sheet is large, deletion may take longer—consider error handling with retries for transient issues.

Did this answer your question?