Get Spreadsheetlight working

Spreadsheetlight is a dotnet library for creating Excel documents with all it’s wonderful features. The Spreadsheetlight nuget has no dependencies on nuget packages, but does have a dependency on Open XML SDK 2.0. This can be installed with the DocumentFormat.OpenXml 1.0.0 nuget.

But after a while everything stopped working, because you tried updating the DocumentFormat.OpenXml to the latest version 2.5.0.

An unhandled exception of type ‘System.TypeLoadException’ occurred.
Additional information: Could not load type ‘DocumentFormat.OpenXml.Spreadsheet.SmartTags’ from assembly ‘DocumentFormat.OpenXml, Version=2.5.5631.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35’.

An unhandled exception of type ‘System.IO.FileLoadException’ occurred.
Additional information: Could not load file or assembly ‘DocumentFormat.OpenXml, Version=2.5.5631.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35’ or one of its dependencies. The located assembly’s manifest definition does not match the assembly reference.

Solution

Revert back to DocumentFormat.OpenXml version 1.0.0

Install-Package DocumentFormat.OpenXml -Version 1.0.0

Remove the assemblyBinding from the app.config

<configuration>
  <runtime>
    <assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">
      <!-- Remove dependentAssembly for DocumentFormant.OpenXml -->
      <dependentAssembly>
        <assemblyIdentity name="DocumentFormat.OpenXml" publicKeyToken="31bf3856ad364e35" culture="neutral" />
        <bindingRedirect oldVersion="0.0.0.0-2.5.5631.0" newVersion="2.5.5631.0" />
      </dependentAssembly>
    </assemblyBinding>
  </runtime>
</configuration>

About erictummers

Working in a DevOps team is the best thing that happened to me. I like challenges and sharing the solutions with others. On my blog I’ll mostly post about my work, but expect an occasional home project, productivity tip and tooling review.

View all posts by erictummers →

16 Responses to Get Spreadsheetlight working

Scott Lister says:

February 10, 2015 at 3:38 pm

Thank you so much this worked like a charm. I figured out that I needed to revert the version of the OpenXML and I did that but I was really banging my head against the wall trying to figure out that second manifest error message. Thanks again.

- erictummers says:
  
  February 10, 2015 at 4:08 pm
  
  That’s why I blog this. Happy coding!
  
Ryan Penfold says:

May 5, 2015 at 5:32 pm

Thanks Eric

Maxence says:

November 9, 2015 at 3:47 pm

Thanks!!! You saved my life.

laserlab says:

November 19, 2015 at 7:04 am

Thanks..!!

namdt40 says:

November 20, 2015 at 4:17 pm

thank great

Johannes Grunedal says:

November 23, 2015 at 8:50 am

Thank you Eric! Works great.

Vinicius Moreira says:

November 27, 2015 at 1:54 pm

Thanks MAN!!!

Francisco Vera says:

December 2, 2015 at 7:02 pm

Thank you, now I can continue with my job.

Harish says:

February 29, 2016 at 7:42 pm

Thanks man…!!!

Emil says:

March 27, 2016 at 8:27 am

Got it to work with your help thanks!

Rafik says:

May 6, 2016 at 6:38 am

Thanks MAAAAAAAAAAAAAAAAAAAN

planetregin says:

June 9, 2016 at 2:26 pm

Thank you! Thank you! Thank you! Saved quite a lot of frustration. 🙂

Juan Bolanos says:

September 13, 2016 at 9:46 pm

Hey Thanks a lot Eric! you saved my day!

Wilson says:

October 10, 2016 at 7:16 pm

thanks eric so much!

Anh Lân says:

January 7, 2017 at 7:36 am

You saved the day, sir. Thank you!