Read Range

Common

• DisplayName - The display name of the activity.

Input

• Range - The range that you want to read. If the range isn't specified, the whole spreadsheet is read. If the range is specified as a cell, the whole spreadsheet starting from that cell is read. Only string variables and strings are supported.
• SheetName - The name of the sheet in which the range that you want to read is. By default, this is filled in with "Sheet1." Only String variables and strings are supported.

Misc

• Private - If selected, the values of variables and arguments are no longer logged at Verbose level.

Options

• AddHeaders - When selected, the column headers from the specified spreadsheet range are also extracted. By default, this check box is selected (set to True).

• PreserveFormat - Select this option to read the values as they are displayed in the range (e.g. currency, date, text). The actual number formatting is not retained, only the way in which data is displayed. By default, the option is not selected.

  Note: Selecting the PreserveFormat check box might cause performance issues on large ranges. This happens because once this check box is selected, the cells are read one by one, instead of being read in bulk.
• UseFilter - When selected, the activity does not read what has been filtered out of the specified range. By default, this check box is not selected, and therefore the entire range is read, regardless if some information has been filtered out.

Output

• DataTable - Stores the data extracted from the specified Excel range in a DataTable variable. Only DataTable variables are supported.