Could not load file or assembly ClosedXML


#1

Hello, I am currently on test phase on a robot and encountering this issues:

1. Robot stopped due to the below error. Try Catch is wrapped around the process error found, but seems like the error was more fundamental, it stopped the robot. Log said:

Error {“message”:“Could not load file or assembly ‘ClosedXML, Version=0.87.0.0, Culture=neutral, PublicKeyToken=XXX’ or one of its dependencies. 指定されたファイルが見つかりません。”,“level”:“Error”,“logType”:“User”,“timeStamp”:“2018-06-30T08:35:04.9021654+09:00”,“fingerprint”:“XXX”,“windowsIdentity”:“XXX”,“machineName”:“XXX”,“processName”:“XXX”,“processVersion”:“XXX”,“fileName”:“XXX”,“jobId”:“XXX”,“robotName”:“XXX”}

2. Went googling about ClosedXAML, and found some VB.net articles to install manually the ClosedXML.dll, but I am not sure since we’re using the client’s environment and we need pretty lengthy procedures to have permit to install anything, and it was not even in UiPath forum.

3. What made me even not sure was that the robot works daily, and it has been about 10 days, and only 2 days they fail with the same error above. So there are days when it works fine. If a dll file is missing, I think it shouldn’t work at all.

4. Additional info:
UiPath Version: 2018.1.4
UiPath.Excel.Activities Package Version: 2.3.6660.23035

So far the error appeared twice on different machine, and reinstalling robot was done, but the error still occured then.

Notice: could not easily upgrade any version of this since there are some previous robots working, we need to test it for sometime before applying to upgrade any version.

Any help would be appreciated.

EDIT: (added information)

Looked for my Studio and found the ClosedXML is installed in version 0.87.1.0 (and the log said error was dould not load 0.87.0.0 (version below). Thought this could be the problem, but cannot find where the ClosedXML setting is, and still wonder why they work sometimes too.


#2

Again sorry for direct pointing, but could you kindly help on this, @ovi?


#3

Let me understand:
-when did this error appear?
-those workflows worked? If so, with what version of excel and robot?
-is the closed xml package v0.87 downloded on the robot machine?


#4

Hello @Gabriel_Tatu, thank you for your response.

-when did this error appear?

When reading an Excel file using Read Range on Excel Application Scope.

.

-those workflows worked? If so, with what version of excel and robot?

It worked mostly. But, there are days when they failed (not always failing).
UiRobot version 18.1.4.0, Excel 14.0.7145.5000 (32bit), Microsoft Office Proffesional Plus 2010.
UiPath.Excel.Activities Package Version: 2.3.6660.23035.
When failing also using the same machine, the same robot and the same Excel version.

.

-is the closed xml package v0.87 downloded on the robot machine?

Never directly installed it, but when checked from Studio, ClosedXML version 0.87.1.0 is installed. But when error happened, the log said the ClosedXML version 0.87.0.0 could not be loaded (the version is difference).


#5

Hi

Now I am facing same problem. yesterday It’s working fine.

System error at initialization: Could not load file or assembly ‘ClosedXML, Version=0.87.0.0, Culture=neutral, PublicKeyToken=fd1eb21b62ae805b’ or one of its dependencies. The system cannot find the file specified. at Source: Read range settings

Studio I am using is 2018.2

please help


#6

Hi @irahmat, have you tried to uninstall and reinstall the Excel activities?


Getting "Could not load file or assembly 'UiPath.Interop, Version=9.0.6844.26814' error
#7

I followed this solution

and it’s works.


#8

Nice to hear it worked for you.