Get Column

Retrieves data from a specific column 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 there is an error, the automation still continues until the end of execution.

Input

• Excel File Descriptor - The opened Excel file descriptor id. This ID is generated by the Open Excel or the Create Excel node.
• Column Name - The name of the column that you want to retrieve data from. (e.g. A or F)

Output

• Column Data - Data returned from the column specified. (e.g ["Name", "John", "Mary", "Sam", "Jane"])

Options

• Target - Defines which column to get data from. Options available are:
  • Active Column
  • Specific Column