Skip to main content

Get Row

Gets a row from an Excel file

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 true, no error is caught when the project is executed even if the Catch node is used.

Input​

  • Excel File Descriptor - Opened excel file descriptor id. This ID is generated by the Open Excel or the Create Excel node.
  • Row Number - The row number to retrieve. (e.g. 4 or 9)

Output​

  • Row - The selected row values as JSON output (e.g. {"location":"Boston", "name":"Jane", "age":48})
  • Row Number - The row number of the selected row. (e.g. 4)

Options​

Here's a corrected version:

  • Target - There are five options:
    • First Row: Reads the first row in the sheet.
    • Next Row: Reads the row following the active cell.
    • Previous Row: Reads the row preceding the active cell.
    • Specific Row: Reads a particular row (specified using the "Row Number" input).
    • Last Row: Reads the last row in the sheet.
  • Header - If true, the first row of the Excel file will be treated as headers and their names will be used as the keys in the returned dictionary.
  • Jsonify - Transforms the header names into a JSON-friendly format by converting them to lowercase and replacing spaces with underscores.