Is it possible to read an Excel file referenced in another Excel application scope?

Help Studio
, ,
4

That’s absolutely right
I was even using excel based activities but I observed lot of stability with workbook activities in its later version
So that’s why I suggested based on output I saw

And

For this
try using a KILL PROCESS activity and mention as “EXCEL” in ProcessName propert and then use Write range activity

And try to keep the above set of activities inside a TRY block of try catch activity
So that even it fails it will go to CATCH block where we can use again a kill process as mentioned above and a write range activity followed by that.

This will ensure even if the activity fails it will get retried for one time atleast

If we want to retry multiple times
Use a RETRY SCOPE activity and mention the activity kill process and write range from workbook in ACTION block and leave the condition empty and mention the number of retries we want in property panel

Hope this would help you

Cheers @Kirigirisu_Coin

1 Like