Scenario: Read Range activity in excel application scope
Steps to reproduce: Use certain excel files but not others
Current Behavior: Throws unhandled .NET Framework exception
Expected Behavior: Read file and return excel DataTable
Studio/Robot/Orchestrator Version: 2016.2.6379
Last stable behavior: 2017-08-07
Last stable version: 2016.2.6379
OS Version: Windows 7 Enterprise 64-bit
Others if Relevant: (workflow, logs, .net version, service pack, etc): .NET 4.0.30319.42000 / Excel.Activities 2.0.6382.14545
My UiPath robot is suddenly crashing when reading certain excel files (my workflow consists only of a Read Range activity in the excel application scope). I have been doing this successfully for about a month and the only relevant difference I can think of is the Microsoft “July 2017 Preview if Quality Rollup for .NET Framework”. After seeing the issue for the first time, I updated the Excel.Activities to the newest version, but it doesn’t make a difference.
There appears to be no rhyme or reason to why certain files work and others produce this error. My co-worker has basically the same software installation on a different machine, but our behaviour is inconsistent: there is a file that works for me, but not for him.
I’ll try to find a minimal example for an excel file I can share that produces the error, but it’s hard to isolate the issue.