ClosedXML - Could not load file or assembly

.net closedxml
Ethel Patrick picture Ethel Patrick · Jan 20, 2016 · Viewed 18.7k times · Source

I am trying to use ClosedXML to produce excel documents within an application however when ever I try to run it I receive a could not load file or assembly server error. 

Could not load file or assembly 'DocumentFormat.OpenXml, Version=2.5.5631.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35' or one of its dependencies. The system cannot find the file specified.

I have seen several solution to this that include changing the 'Copy Local' value for the .dll in its properties and adding the assembly directly to the web.config.

I'm using Visual Studios 2010 and the dll properties does not include a 'copy local' entry. Then when I enter the following assembly in the web config I still get the same server error message. I got the assembly from the error message provided. 

 <add assembly="ClosedXML, Version=0.76.0.0, Culture=neutral, PublicKeyToken=fd1eb21b62ae805b"/>

Answer

Ethel Patrick picture Ethel Patrick · Jan 20, 2016

After going crazy searching for answers and finally posting a question, I came across the simplest answer and once I referenced the additional .dll everything worked correctly.

To use ClosedXML you must reference the DocumentFormat.OpenXml.dll:

DocumentFormat.OpenXml.dll for NET 4.0+

Related questions

What are the differences between the EPPlus and ClosedXML libraries for working with OpenXML?

I'm trying to choose between ClosedXML, EPPlus, and possibly SpreadsheetLight. What reasons might I consider for picking one over the others?

Read More
Autofit column in ClosedXML.Excel

I understand that the question stupid and from FAQ, but i cant set auto width in excel columns (using ClosedXML.Excel library) my code: var wb = new XLWorkbook(); var wsDep = wb.Worksheets.Add("MyWorksheet"); wsDep.Columns("A").AdjustToContents(); wsDep.Columns("…

Read More
Export big amount of data from XLSX - OutOfMemoryException

I am approaching to export a big amount of data (115.000 rows x 30 columnd) in Excel OpenXML Format (xlsx). I am using some libraries like DocumentFormat.OpenXML, ClosedXML, NPOI. With each of this, OutOfMemoryException is thrown because the representation of the …

Read More