Read Range
Read range of excel sheet.
Reads the value of an excel range and stores it in a data table variable.
This activity can only be used after the Open Excel File activity.
Input
The range is specified in A1:E10
or A1
format. A1:E10
will select all cells of the first five columns from row 1 to 10. A1
will select first cell from first row.
Add Headers :
True
- column headers from the specified excel range will be extracted.False
- column headers from the specified excel range will not be extracted.Default
Preserve Format :
True
- keeps the formatting of the excel range that you want to read.The available formatting properties are:
CellName
Format Specifier
Value
False
- Read the range without formatting.Default
Output
Output :
DataTable Variable
TheDataTable
variable that stores the data extracted from the specified excel range.
Last updated