Get Row

Retrieves all data from a specific row in an Excel worksheet. Returns cell values as a dictionary with cell addresses as keys.

Common Properties

• Name - The custom name of the node.
• Color - The custom color of the node.
• Delay Before (sec) - Waits in seconds before executing the node.
• Delay After (sec) - Waits in seconds after executing node.
• Continue On Error - Automation will continue regardless of any error. The default value is false.

info

If the ContinueOnError property is set to true, no error is caught when the project is executed even if a Catch node is used.

Input

• Client Id - The client ID from the Connect node (optional if using direct credentials).
• Workbook Id - The workbook ID from Get Workbook or Create Workbook node.
• Worksheet Name - Name of the worksheet to read from. Default is "Sheet1".
• Row Number - Row number to read (1-based, e.g., 1 for first row).

Options

• Credentials - OAuth2 credentials (optional, alternative to using Client ID).
• Column Range - Column range to read (e.g., A:Z, A:AA). Default is "A:Z".
• Include Empty Cells - When true, includes empty cells in the result. Default is true.

Output

• Result - Dictionary mapping cell addresses to values. Cell addresses use Excel format (e.g., "$A$1", "$B$1").

Examples

Read Entire Row:

// Input
Row Number: 5

// Output - Result
{
  "$A$5": "John Doe",
  "$B$5": "100",
  "$C$5": "Active",
  "$D$5": ""
}

Process Row Data:

Get Workbook
  → Get Row (row 1, read headers)
  → Loop through columns
  → Get Row (row 2+, read data)

Use Cases

• Read header rows
• Extract specific data rows
• Process rows one by one in loops
• Validate row contents
• Read configuration rows

Tips

• Row numbers are 1-based (first row is 1)
• Cell addresses include $ symbols in Excel format
• Empty cells are included if Include Empty Cells is true
• Use Column Range to limit the columns read for better performance
• For reading multiple rows, consider using Get Range instead

Common Errors

ErrInvalidArg - "Row Number must be greater than 0"

• Solution: Provide a valid row number (1 or greater)

ErrNotFound - "Row not found in worksheet"

• Solution: Verify the row number is within the worksheet bounds

ErrInvalidArg - "Workbook Id cannot be empty"

• Solution: Ensure you've called Get Workbook first