Read Range

You can select this activity to read and save data from a specified excel workbook cell range. This data can be used in other activities such as Write Range.

This table lists the properties for the activity.

Property Type Property Name Data Type Description
Common Continue on error Boolean Select the check box to continue the RPA flow even if the activity fails. This check box is selected by default.
Input Range String The range of data that must be read. If the range is not specified, the value of the entire spreadsheet is considered. If the range is specified as a cell, the entire spreadsheet starting from the specified cell is read. Only string variables and strings are supported. A custom range can also be added. For example, F10: G29
Workbook OneDriveItem The file or document stored in OneDrive from which data must be read.

You can retrieve the metadata of a OneDrive item by using the OneDrive activities for an existing workbook or by using the output from the Create Workbook activity.

Worksheet Name String The name of the worksheet from which data must be read.
Misc Display Name <String> The name to be dis- played for the activity.
Output Data Table DataTableSystem.Data.DataTable Stores the data extracted from the specified Excel range to a Data table variable. Only Data table variables are supported.
Response Code Int32 Response code for the activity. Possible values:
  • 200 to 290: Indicates a successful response or valid output.
  • 400 to 499: Indicates client error responses.
  • 500 to 599: Indicates server error responses.