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

• 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.

• Range : String Argument The excel range to be read.

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 The DataTable variable that stores the data extracted from the specified excel range.