Read Range

UiPath.Excel.Activities.ExcelReadRange

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 or Use Excel File activities.

Note: Due to a software limitation, reading cells that have currency format only retrieves a maximum of 4 decimal places.

Properties

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.

Example of using the Read Range activity

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