Hi everyone!
I got an exception I haven’t found referenced:
System exception:
Could not parse Microsoft Excel version: $
Comment:
I cannot find a reference to this error, it seems a leak memory from Excel (0X00… like) but I get this error message instead. I solved it by going back to old guard methods
Workaround:
I happened when trying to open and close same excel file to get different sheets in a For Each loop.
Im Using Excel Scope, assigning Workbook variable and closing it after each extraction (Excel application scope, Read range, Colse Workbook)
Solution:
Right now, I’ve solved it by adding a delay of 2 seconds after Close Workbooc activity, I know it’s weird but it works.
I hope it can help someone, welcom anyone who wants to take the lead
I still think that must be a good a pproach to aim @shetanshudhar solution first, it’s working normally and then, if need so, attack it like this.
It happened to me in 2 more projects lastly.
The mention of 3 seconds does ring a bell. Could you try with the latest Excel activity package? There is now a new property called InstanceCachePeriod of which default value is 3000ms, see more here:
That sounds really good, Cheers!
Could you specify since which version of Studio do we have this new feature available?
I just checked my case, we have 20.4 on premises and I’m already targetting to the max Excel.Activities version, 2.8.6.
I can’t find in releases page when it came.
Hug!