Write Range
You can select this activity to write a DataTable variable to a specified cell range in an excel 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 | Data Table | DataTable | The data table from which information must be considered for the specified range. Only DataTable variables are supported. |
| Range | String | The cell range where the data must be written. You can specify the range using full notation or by providing only the starting cell.
Example: A10:B20 or C30 |
|
| Workbook | OnedriveItem | The file or document stored in OneDrive that must be modified.
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 in which the range of cell data must be written. Only String variables and strings are supported. | |
| Misc | Display Name | <String> | The name to be dis- played for the activity. |
| Output | Response code | Int32 | Response code for the activity. Possible values:
|