ReadRanges
When to use the ReadRanges activity
This activity helps you read the data from a specified range and returns the output as a Datatable.
Figure 1
|
Activity Name |
Picture |
|
ReadRanges |
|
|
Figure 1.1 |
S.no |
Description |
|
1 |
Check this box if the input range contains headers and include it as column headers for the Datatable |
|
|
2 |
Specify the range of cells where you are required to read the data |
|
|
3 |
Specify the sheet name in which you are required to read a range |
|
|
4 |
Displays the action that the activity performs in the workflow |
|
|
5 |
Specify whether to continue executing the workflow even if the activity fails |
|
|
6 |
Define the condition that you prefer to validate. It supports only Boolean value |
IncludeColumnHeaders should be checked if you require the header column for processing.
Activity: The ReadRanges activity helps you read the data from a worksheet over a specified co-ordinate of an excel and store as a datatable variable.