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 | Data Type | Description |
|---|---|---|---|
| Input | Range | String | The range of data that must be read. If the range is not specified, the value of the entire spread- sheet 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 support- ed. |
| Workbook Path | String | The location of the workbook. | |
| Worksheet Name | String | The name of the worksheet that must be read. | |
| Output | Data Table | DataTable System.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:
|