Read Range
You can select this activity to retrieve values from a specific range of cells in a worksheet. The values are retrieved in a data table.
This table lists the properties for the activity.
| Property Type | Property Name | Description |
|---|---|---|
| Input | Range | 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. |
| Workbook Path | The location of the workbook. | |
| Worksheet Name | The name of the worksheet that must be read. | |
| Output | Data Table | Stores the data extracted from the specified Excel range to a Data table variable. Only Data table variables are supported. |
| Response Code | Response code for the activity. Possible values:
|