Read Column

Read column values from excel sheet.

Reads the values from a column beginning with the cell specified in the Column Name property field, and store it in a variable.

This activity can only be used after the Open Excel File activity.

Input

• Input : ExcelHandle Variable A variable name that references the opened excel filehandle.
• Sheet Name : String Argument The name of the sheet in which the column of data is to be read.
• Column Name : String Argument The column name to be read.

The column name is specified in A format.

• Preserve Format :

  • True - keeps the formatting of the excel column that you want to read.

  • False - Read the column without formatting. Default

Output

• Column Data: IEnumerable<object>

  The variable containing the specified column of data.