Skip to main content

Get Column

Retrieves all cell values from a specific column 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.
  • Column Name - Column letter to retrieve (e.g., A, B, C, AA).

Output​

  • Result - 2D array containing cell addresses and their values. Each row in the array has two elements: [cell_address, cell_value].

Options​

This node has no additional options.

Example​

Getting a column:

// File Descriptor: message.excel_fd
// Column Name: "A"
// Output: [
//   ["$A$1", "Header"],
//   ["$A$2", "Value1"],
//   ["$A$3", "Value2"],
//   ...
// ]

Getting column from multi-letter column:

// Column Name: "AA"
// Returns all values from column AA

Processing column data:

// After Get Column, iterate through the result:
// For Each with message.Result
// message.item[0] = cell address (e.g., "$A$1")
// message.item[1] = cell value

Getting product prices:

// Column Name: "D"  // Price column
// Then calculate sum or average from the results

Tips​

  • The column is retrieved from row 1 to the last used row.
  • Only cells with data are included (based on the used range).
  • Column names are case-insensitive ("A" and "a" are the same).
  • Cell addresses in the output include dollar signs (e.g., "$A$1", "$A$2").
  • For getting multiple columns efficiently, use Get Range instead.

Common Errors​

ErrorSolution
Column Name cannot be emptyProvide a column letter (e.g., A, B, C)
Invalid column nameUse valid Excel column letters (A-Z, AA-ZZ, etc.)
Invalid File DescriptorEnsure the Open Excel node was executed first