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.
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.
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.
Last updated