Could not load file or assembly ClosedXML - KB

Could not load file or assembly ClosedXML

Approach 1 

Excel Activities ClosedXML is one of the dependencies required to operate and this issue generally occurs if the ClosedXML package was corrupted/missed.

  • Please navigate to the package managers window (Ctrl + P).
  • Navigate to the All Packages . 
  • Search for excel activities.
  • Check the version of ClosedXML package in dependencies as shown below:



    Image_2019-05-22_21-04-17.png
     
    - Navigate to the location " %Userprofile% /.nuget/packages" 
  • “ClosedXML” folder is present then delete it


    Image_2019-07-24_00-57-08.png



    -  Install the ClosedXML package version mentioned in above screenshot from manage packages:

    Image_2019-05-22_21-08-49.png




    Approach 2 

    Please follow the below steps & let me know if this helps. 
  • Open %userprofile% in your affected Robot system
  • Navigate to “.nuget” folder.
  • Take a backup of the “packages” folder to a different location.
  • Delete the current folder in .nuget location.

    Reason: This would delete all the packages thus allowing to Robot to download the packages again when a process is executed.
  • Now launch Studio & execute the process. This should complete the auto installation of dependent package 

    Reason: The process will download again with all the required dependencies.


    Preferred approach is 1 as with approach 2, robot has to download all the dependencies for all packages/processes and first execution of almost all processes may take some time.