Read Sheet
Read the excel sheet.
Reads the value of an excel sheet and stores it in a DataTable
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 file handle.Sheet Name :
String Argument
The sheet name of the workbook to be read.
Options
Start Column :
String Argument
Starting Column Name of the excel sheet to be read.Start Row :
Integer Argument
Starting Row Index of the excel sheet to be read.Add Headers :
True
- column headers from the specified excel range will be extracted. If set to True, all the values in the header should be unique.False
- column headers from the specified excel range will not be extracted.Default
Preserve Format :
True
- keeps the formatting of the excel sheet that you want to read.The available formatting properties are:
CellName
Format Specifier
Value
False
- Read the sheet without formatting.Default
Output
Output :
DataTable Variable
TheDataTable
variable that stores the data extracted from the specified excel sheet.
Last updated