Skip to main content

Get Column

Retrieves all data from a specific column 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".
  • Column Letter - Column letter to read (e.g., A, B, Z, AA). Case-insensitive.

Options​

  • Credentials - OAuth2 credentials (optional, alternative to using Client ID).
  • Row Range - Row range to read (e.g., "1:100"). Default reads all rows with data.
  • Include Empty Cells - When true, includes empty cells in the result. Default is true.

Output​

  • Result - Dictionary mapping cell addresses to values.

Examples​

Read Column:

// Input
Column Letter: "B"

// Output - Result
{
  "$B$1": "Name",
  "$B$2": "John",
  "$B$3": "Jane",
  "$B$4": "Bob"
}

Use Cases​

  • Extract column data for analysis
  • Read header columns
  • Process columnar data
  • Validate column contents
  • Export specific columns

Tips​

  • Column letters are case-insensitive
  • Use Get Range for reading multiple columns efficiently
  • Empty cells included based on Include Empty Cells option

Common Errors​

ErrInvalidArg - "Workbook Id cannot be empty"

  • Solution: Ensure you've called Get Workbook first