Skip to content

The Dummy Programmer

Stories of daily programming

  • Home
  • The Dummy Programmer Robot
    • Overview
    • Version history & downloads
    • Tutorials
      • TDP Robot – The basics
      • A simple SQL Server backup solution
      • A simple SQL Server backup solution – A next step
  • My other dummy projects
  • Games
    • Space Y: An Asteroids clone
  • Services
    • What’s my user agent
    • What’s my IP address
  • About
  • Toggle search form

Could not load file or assembly ‘DocumentFormat.OpenXml, Version=2.7.2.0

Posted on April 28, 2021April 28, 2021 By

I’m developing a C# application which uses the library ClosedXML in order to generate XLSX files, and I ran into this error: “Could not load file or assembly ‘DocumentFormat.OpenXml, Version=2.7.2.0, Culture=neutral, PublicKeyToken=8fb06cb64d019a17’ or one of its dependencies. The system cannot find the file specified.
File name: ‘DocumentFormat.OpenXml, Version=2.7.2.0, Culture=neutral, PublicKeyToken=8fb06cb64d019a17′”.

It’s weird, because in my development environment it works all ok, but running the program in the production machine I get the error above.

To be honest I couldn’t find an explanation, but here is a quick and dirty solution…

Go to Nuget site at this address:

https://www.nuget.org/packages/DocumentFormat.OpenXml/2.7.2

And click on the link “Download package”.

You should have download a file named “documentformat.openxml.2.7.2.nupkg”. As many of you will know, a Nuget package is nothing else but a zip file with a different extension. So rename the file from “documentformat.openxml.2.7.2.nupkg” to “documentformat.openxml.2.7.2.zip” and extract the content with your favorite zip extractor.

In the subfolder “lib” take the file “DocumentFormat.OpenXml.dll” (choose the correct folder depending on the version of .NET you are using) and copy this file over the version you are using in your production machine.

Also remember that you may need to restart your application after copying the library. For example I was developing a Windows service, and I needed to stop and start the service to see it work.

Have a nice day!

C#, ClosedXML

Post navigation

Previous Post: Multi-tenant database in SQL Server
Next Post: The Dummy Programmer Robot at last!

Related Posts

A chat program built in C# with .NET socket library C#
Reading data from a NetworkStream object in C# C#
Capture screen using C# C#
Working with C# async / await keywords (part 3 of 3) C#
Working with C# async / await keywords (part 2 of 3) C#
Push notifications library with C# and .NET Framework C#

Search

Related posts

  • Sql Server error using a database with a CLR assembly
  • Load a huge amount of data in a Sql Server table
  • TDP Robot version 1.0.0.0
  • TDP Robot version history

Categories

  • .NET 6 (1)
  • AJAX (1)
  • Android (2)
  • Apache (4)
  • ASP.NET (9)
  • ASP.NET MVC (3)
  • Avalonia UI (1)
  • BCP (1)
  • Bitlocker (2)
  • C# (14)
  • CentOS (4)
  • ClosedXML (1)
  • CLR (1)
  • DNS (1)
  • Encryption (3)
  • Excel (2)
  • FuelPHP (3)
  • Games (2)
  • Google Chrome (1)
  • GSuite (1)
  • HTML (1)
  • Imagick (2)
  • Javascript (1)
  • Kindle (1)
  • LAMP (3)
  • Linux (6)
  • MariaDB (2)
  • Mathematics (2)
  • MySql (4)
  • NPOI (1)
  • Office 365 (1)
  • Perl (1)
  • PHP (6)
  • Programming (1)
  • Remote desktop (1)
  • SFTP (2)
  • Sockets (3)
  • Sql Server (18)
  • Sql Server 2016 (14)
  • Sql Server 2019 (1)
  • SSL (2)
  • Task scheduler (1)
  • Telerik ASP.NET AJAX (2)
  • The Dummy Programmer Chat (2)
  • The Dummy Programmer Robot (6)
  • Threading (5)
  • Tools (1)
  • TPL (3)
  • TypeScript (3)
  • Ubuntu (4)
  • Virtualization software (3)
  • Visual Studio (1)
  • Visual Studio Code (2)
  • Web fonts (1)
  • Web programming (6)
  • Windows (12)
  • Windows 10 (15)
  • Windows Forms (1)
  • Windows Server (6)

Copyright © 2023 The Dummy Programmer | Privacy Policy | Terms of use |

Powered by PressBook Masonry Dark