What is an Excel Application Scope?
Excel application scope opens an Excel workbook and sets the scope for Excel activities.
When you complete this activity, the specified workbook and the Excel application are closed.
In Excel Automation we will use two types of Activities available
1) Excel Activities
2) Workbook Activities
Excel Activities :
1) To use excel activities that machine should have MS office Excel Application.
2) All the activities should place with in the excel application scope activity.
3) You may not be able to access password protected sheets.
4) Workflow still execute if excel file is in open.
Work Book Activities :
1) We don't need excel application installation.
2) Excel application scope also not required.
Note (Drawback) : if excel file is in open then our workflow will fail.
Excel Application Scope Activity
Read Range
Output Data Table
Log Message