WriteRange
When to use the WriteRange activity
This activity helps you write the data into an excel.
Figure 1
Activity Name |
Picture |
WriteRange |
Figure 1.1
|
S.no |
Description |
1 |
Specify the Datatable variable which you are required to write on a specified range |
|
2 |
Check this box if the input range contains headers and include it as column headers for the Datatable |
|
3 |
Specify the password string if the sheet is password protected |
|
4 |
Specify the input range where you are required to write the data |
|
5 |
Specify the sheet name in which you are required to write a range |
|
6 |
Displays the action that the activity performs in the workflow |
|
7 |
Specify whether to continue executing the workflow even if the activity fails |
|
8 |
Define the condition that you prefer to validate. It supports only Boolean value |
Password is to be provided only if the worksheet is password protected.
Activity: The WriteRange activity helps you write data into a worksheet over a specified range.