Read an Excel File in C#: ExcelDataReader, ClosedXML, and No-Library OpenXML
How to read an Excel file in C#: load .xlsx and .xls into objects with ExcelDataReader, ClosedXML, ExcelMapper, or plain OpenXML, no Office or Interop.
I'm a Senior Customer Success Engineer at Duende Software, where I help teams succeed with Duende IdentityServer. I've been working with .NET for over a decade, and I love writing about ASP.NET Core, C#, and web development. When I'm not coding, I'm probably traveling with my wife Nicole or going on long walks with our two dogs.
How to read an Excel file in C#: load .xlsx and .xls into objects with ExcelDataReader, ClosedXML, ExcelMapper, or plain OpenXML, no Office or Interop.
My site has always been a blog focused on educating readers with information that helps them solve immediate, urgent issues. That said, I’ve recently been experimenting with tools that can solve particular issues right in the browser. Wow!
Granted, these aren’t the world’s hardest technical issues, but I think they’re fun and might help developers move forward. Some of these tools are purely JavaScript, and some use the .NET Wasm runtime to give an in-browser .NET experience (when it’s critical to do so).
Give them a shot at the Tools page. 🧰