Read Column

You can select this activity to retrieve cell values from a specific column in a worksheet. This activity returns the column value as an array of objects.

This table lists the properties for the activity

Property Type Property Name Data Type Description
Input Output Worksheet Name String The name of the worksheet from which data must be read.
Column Number String The column number to be read.
Workbook Path String The location of the workbook.
Results Object[] An array containing information of the specified column.
Response code Int32 Response code for the activity. Possible values:
  • 200 to 290: Indicates a successful response or valid output.
  • 400 to 499: Indicates client error responses.
  • 500 to 599: Indicates server error responses.