Reads the value of an Excel range and stores it in a
DataTable variable. 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. Can only be used in the Excel Application Scope activity.
Due to a software limitation, reading cells that have currency format only retrieves a maximum of 4 decimal places.
- DisplayName - The display name of the activity.
- 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.
- Private - If selected, the values of variables and arguments are no longer logged at Verbose level.
- 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(slower) - Selecting this check box keeps the formatting of the range that you want to read. By default, the check box is cleared.
Selecting the PreserveFormat(slower) 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.
- DataTable - Stores the data extracted from the specified Excel range in a
DataTablevariables are supported.
You can see how the Read Range activity is used in an example that incorporates multiple activities.
To exemplify how to use this activity, we have built an automation project which also includes a Read Range activity.
You can check and download the example from here
Updated about a year ago