Get Row

Retrieves all cell values from a specific row in the active sheet.

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 the node.
• Continue On Error - Automation will continue regardless of any error. The default value is false.

info

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

Input

• File Descriptor - File descriptor of the Excel file. This is the identifier returned by the Open Excel node.
• Row Index - Row number to retrieve (1-based index, e.g., 1, 5, 10).

Output

• Result - Dictionary object mapping cell addresses to their values. The structure depends on the Include Hyperlinks option:
  • Without hyperlinks: {"$A$1": "value1", "$B$1": "value2", ...}
  • With hyperlinks: {"$A$1": {text: "value1", hyperlink: "http://..."}, ...}

Options

• Include Hyperlinks - Whether to include hyperlink information. Default is false.
  • false - Returns cell values as strings
  • true - Returns objects with text and hyperlink properties

Example

Getting a row without hyperlinks:

// File Descriptor: message.excel_fd
// Row Index: 5
// Include Hyperlinks: false
// Output: {"$A$5": "Product", "$B$5": "100", "$C$5": "In Stock"}

Getting a row with hyperlinks:

// Row Index: 1
// Include Hyperlinks: true
// Output: {"$A$1": {text: "Website", hyperlink: "http://example.com"}, ...}

Processing row data:

// After Get Row, access specific cells:
// let productName = message.Result["$A$5"];
// let quantity = message.Result["$B$5"];

Reading multiple rows:

// Loop through row indices 1 to 10
// For each iteration:
// - Get Row with Row Index: message.loop_index
// - Process message.Result

Tips

• The row index is 1-based (first row is 1, not 0).
• Only cells within the used range are included in the result.
• Cell addresses in the output include the dollar signs (e.g., "$A$5", "$B$5").
• Use this when you need all values from a specific row for processing.
• For getting multiple rows efficiently, use Get Range instead.

Common Errors

Error	Solution
Row Index must be greater than 0	Provide a valid row number (1 or higher)
Invalid File Descriptor	Ensure the Open Excel node was executed first