Mayyur
(Mayyur)
January 16, 2020, 5:45am
1
Hello Team,
I’m confused why do we use Excel app scope read range if we can read directly from workbook read range activity,
Please guide
anmolk171
(Anmol Kumar)
January 16, 2020, 5:53am
2
Here you can find the clear difference.
Excel activities can only be used within the Excel Application Scope. This effectively opens Excel albeit quickly. Some of the activities like executing macros will only run if within the application scope.
Workbook activities do not require Excel to be open so if for example, all you need to do is read in a range then you can use this.
Generally I would advise using Excel Application Scope as it doesn’t take long to run and down the line you may want to perform more actions with your Excel fi…
Hope it will clear the doubt.
Best!!
Anmol
Mayyur
(Mayyur)
January 16, 2020, 5:57am
3
What if i use WB read range in excel applicatn scope
anmolk171
(Anmol Kumar)
January 16, 2020, 6:06am
4
@Mayyur - This will make no sense and it will throw the error. Because in application scope you will enter the path and UiPath will open it before moving further then in WB activity you need to again give the path of file and UiPath needs to again open it which will eventually throw the error.