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:
|