Read Column
Read column values from excel sheet.
Last updated
Read column values from excel sheet.
Last updated
Reads the values from a column beginning with the cell specified in the Column Name property field, and store it in a variable.
Input : A variable name that references the opened excel filehandle.
Sheet Name : The name of the sheet in which the column of data is to be read.
Column Name : 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:
The variable containing the specified column of data.