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:
  • 200 to 290: Indicates a successful response or valid output.
  • 400 to 499: Indicates client error responses.
  • 500 to 599: Indicates server error responses.