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