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