Skip to main content

Get Range

Gets data from a specific range of 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 ContinueOnError property is true, no error is caught when the project is executed even if Catch node is used.

Input​

  • Excel File Descriptor - The descriptor of the opened excel file. This ID is generated by the Open Excel or the Create Excel node.
  • From Cell - The starting cell reference for data retrieval. (e.g. A1).
  • To Cell - The ending cell reference for data retrieval. (e.g. H10).

Output​

  • Range - The specified range of data from the excel file read in data table format.

Options​

  • Target - Selects either a specific range or all ranges for the operation.
  • Headers - Determines whether or not headers are included.
  • Jsonify - Transforms the header names into a JSON-friendly format by converting them to lowercase and replacing spaces with underscores.
info

If the Target property is set to "specific-range", the From Cell and/or To Cell properties need to be set. If the Target property is set to "all-range", the From Cell and To Cell properties can be left empty. The Headers property determines whether or not to retrieve the headers. The Jsonify property converts the retrieved data into JSON format.