Definition and Usage
Read Lark spreadsheet content. You can read a single cell, an entire row, an entire column, or a rectangular range. Choose how to read, then provide the corresponding indexes. Use the output for downstream steps like decisions, loops, or data processing.
Parameter Values
Input Parameters
Parameter Name | Description | Possible Values | Required | Options / Notes |
Lark Sheets | Select the Lark Sheets object to retrieve data from. | Existing Lark Sheets object | Yes | Ensure the target sheet is accessible and authorized. |
Read by | Select how to read from the sheet. | Cell, Row, Column, Range | Yes | Determines which index fields you must fill next. |
Row | Specify row index (starts from 1). | Integer >= 1 | Conditional | Required when Read by = Cell or Row; ignored otherwise. |
Column | Specify column index (starts from 1 or A). | Integer >= 1; A, B, C... | Conditional | Required when Read by = Cell or Column; accepts number or letter. |
Start row | Specify row index (starts from 1). | Integer >= 1 | Conditional | Required when Read by = Range. |
End row | Specify row index (starts from 1). | Integer >= 1 | Conditional | Required when Read by = Range; must be >= Start row. |
Start column | Specify column index (starts from 1 or A). | Integer >= 1; A, B, C... | Conditional | Required when Read by = Range. |
End column | Specify column index (starts from 1 or A). | Integer >= 1; A, B, C... | Conditional | Required when Read by = Range; must be >= Start column. |
Advanced Settings
Parameter | Description | Possible Values | Required | Options / Notes |
Get cell formatting | Retrieve formatting from specified range. | Default; ToString; Returns the formula itself if the cell contains one; Returns the calculation result with cell formatting preserved; Returns the calculation result without preserving cell formatting | No | Applies to reads that may include formulas; choose how formulas and formatting are returned. |
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 outputs the data you read so you can use it later in the workflow. Reading a single cell typically produces a text value. Reading a row or a column typically produces a list of text values. Reading a range typically produces a tabular structure suitable for looping or filtering.
Using Variables in Conditions
You can pass values from earlier steps into this command to make it dynamic—for example, using a variable for the row number or the column letter. In many designers, fields marked with {x} indicate variable support. Use variables to drive which cell, row, column, or range gets read based on prior results or loop counters.
Notes
Ensure the Lark Sheets object is valid and you have permission to read the target sheet.
Indexing starts at 1; column can be numeric (1-based) or letter-based (A, B, C...).
For Range, End row must be >= Start row and End column must be >= Start column.
When reading cells with formulas, choose a formatting option that matches your needs (formula text vs. calculated result; preserve formatting or not).
Large ranges may impact performance; read only what you need.