Write Range
Description
This Activity allows you to transfer data, either as a value or formula, from a DataTable variable to a spreadsheet. You can choose the designated cell range from which it writes the data. If you don't specify the starting cell, it writes the data from cell A1. If the spreadsheet doesn't exist, this Activity will create a new one with the name you specify in the Sheet Name property. This Activity will replace the content in all cells within the specified Range and save the modifications immediately.
Properties
Input
- Add Headers – When true, it writes the column headers to the specified Range.
- Data Table – Specify the Data Table to write the data into the specified cell range. It supports only String variables and strings.
- Spreadsheet – Specify the Excel Workbook instance to write the data.
note
Use Open Spreadsheet activity to create an Excel Workbook instance and Close Workbook to close the instance.
- Starting cell – Specify the cell range from which to start writing the data.
Misc
- DisplayName – Add a display name to your Activity.
- Private – By default, Activity will log the values of your properties inside your workflow. If private is selected, then it stops logging.
Optional
- Continue On Error – It Specifies whether the automation should continue even when the Activity throws an error. If True, the Activity continues without throwing any exceptions. If False, the Activity throws an exception. The default value is False.
note
Catches no error if this Activity is present inside the Try-Catch block and the value of this property is True.
- Sheet Name – The sheet name where you want to write the data into the specified Range. By default, the operation will be performed on the current active sheet.
Example
Download Example
