Excel automation package in the SmartDesigner tool helps users automate the tasks that involve excel. This feature has the capability to interact with all types of excel formats and tasks performed using the excel sheets.
GetExcelObject
When to use the GetExcelObject activity
All other excel activities should be executed within this activity. This activity creates a scope for all excel activities which holds the excel object.
Figure 1
|
Activity Name |
Picture |
|
GetExcelObject |
|
|
Figure 1.1
|
S.no |
Description |
|
1 |
Specify the excel file path |
|
|
2 |
Specify the password string if the workbook is protected by a password |
|
|
3 |
Displays the action that the activity performs in the workflow |
|
|
4 |
Specify whether to continue executing the workflow even if the activity fails |
Password should be provided only for password protected documents.
Activity: The GetExcelObject helps in creating a scope for the particular excel file that is required as the source file in the automation process.