Read Cell
You can select this activity to read data from a specific cell in a worksheet within a workbook. 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 | Cell Address | String | The address of the cell from which the data must be read. For example, A1. |
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 where the value of a specified cell must be read. | |
Misc | Display Name | <String> | The name to be dis- played for the activity. |
Output | Cell Value | String | The contents of the cell. |
Formula | Boolean | The formula contained in a cell. If the cell does not contain a formula, the value specified in the cell is returned. | |
Response Code | Int32 | Response code for the activity. Possible values:
|