Which solution is faster / better?
Is it better to use a For Each inside an Excel Application Scope or an Excel Application Scope inside a for each?
i guess there is no difference since you trying to use both the activities either way.
For each inside the application scope is faster, opening a scope take some time.
What if the ‘for each’ contains many other activities than the excel application scope, is it actually good to keep the excel application scope?
For example, if we have 10 activities to perform inside a for each, 9 of them don’t need an excel app scope, and 1 of them only does need.
Get all the required data into data table modify it and then save it after all loop activities .
Exactly, this is what I did, thank you anyway!