NPOI
a .NET library that can read/write Office formats without Microsoft Office installed. No COM+, no interop. (by nissl-lab)
ClosedXML
ClosedXML is a .NET library for reading, manipulating and writing Excel 2007+ (.xlsx, .xlsm) files. It aims to provide an intuitive and user-friendly interface to dealing with the underlying OpenXML API. (by ClosedXML)
Our great sponsors
| NPOI | ClosedXML | |
|---|---|---|
| 16 | 26 | |
| 5,506 | 4,381 | |
| 1.4% | 2.5% | |
| 9.0 | 9.5 | |
| 1 day ago | 7 days ago | |
| C# | C# | |
| Apache License 2.0 | MIT License |
The number of mentions indicates the total number of mentions that we've tracked plus the number of user suggested alternatives.
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
NPOI
Posts with mentions or reviews of NPOI.
We have used some of these posts to build our list of alternatives
and similar projects. The last one was on 2023-04-14.
- Hola, problema con un crud
-
Is it possible to use Microsoft Word features programatically?
NPOI (Open source, MIT)
-
Is MS Word interop dead now on .NET core?
For .NET Core you can use - https://github.com/nissl-lab/npoi - https://github.com/Jetro223/DocXNETCore
-
What's the best way to read an Excel file into a DataGrid in WinUi 3?
I use NPOI https://github.com/nissl-lab/npoi its a popular package for reading Excel. It is both faster than interop and free (open source).
-
Help needed with .xlsb files
Have you tried NPOI?
-
NPOI Alternative Spreadsheet API Performance Test in C# .NET
Competitor#2 (NPOI - v2.5.6)
- Calling Java from C#
-
cannot create an instance of the abstract type or interface. how to solve this ???
If you are trying to *create* Excel files, then you might take a look at [NPOI](https://github.com/nissl-lab/npoi) which is also open source with a permissive license. There is also [ClosedXml](https://github.com/ClosedXML/ClosedXML), which has these capabilities.
-
Read Data from a Column of an Excel File
I'd like to use NPOI to deal with Excel files. It's open source and you don't have to install Microsoft Office.
-
Read uploaded excel file
EPPlus ExcelDataReader NPOI
ClosedXML
Posts with mentions or reviews of ClosedXML.
We have used some of these posts to build our list of alternatives
and similar projects. The last one was on 2023-10-12.
-
When XML in Word Became Illegal
It's also country specific.
I work on Excel library and the text to number/date feature was one of less fun things to implement at least semi-correctly.
I remember my comment on the PR back then:
-
Visual Studio C#: Is it possible to manipulate Excel file via Visual Studio
Once installed, you can start using ClosedXML directly in your project. Go through their wiki for some sample codes based on what you are trying to achieve in your app.
-
VBA script in Excel runs much slower is Outlook is open
There are alternatives to requiring opening the full Excel application and its resource overhead. Especially given you're simply reading, sorting, and writing. One of the most popular is CloseXML which you add via a NuGet package.
-
Any tips on converting a XLSX file to HTML without using a licensed library?
Time to dig into those open xml docs. Honestly it’s not that bad once you get your bearings. ClosedXML offers a somewhat thin wrapper as well. I’ve used these with great success but they are quite low level.
- I need a Data-Grid that I can copy/paste excel data with
-
adding cell color in Excel file using c#
ClosedXML is an open wrapper around OOXML.
- How do I get Excel column data type with OpenXml?
-
Discovered a NuGet package called ClosedXML. Takes away the pain of dealing with OpenXML
It's open-source: https://github.com/ClosedXML/ClosedXML
- Need help with reading files in C#
- Does anyone have an opensource project they'd like a hand with?
What are some alternatives?
When comparing NPOI and ClosedXML you can also consider the following projects:
EPPlus
Open XML SDK - Open XML SDK by Microsoft
ExcelDataReader - Lightweight and fast library written in C# for reading Microsoft Excel files
DocX - Fast and easy to use .NET library that creates or modifies Microsoft Word files without installing Word.
Report-From-DocX-HTML-To-PDF-Converter - .NET Core library to create custom reports based on Word docx or HTML documents and convert to PDF
MiniExcel - Fast, Low-Memory, Easy Excel .NET helper to import/export/template spreadsheet (support Linux, Mac)
NPOI vs EPPlus
ClosedXML vs Open XML SDK
NPOI vs Open XML SDK
ClosedXML vs EPPlus
NPOI vs ExcelDataReader
ClosedXML vs ExcelDataReader
NPOI vs DocX
ClosedXML vs DocX
NPOI vs Report-From-DocX-HTML-To-PDF-Converter
ClosedXML vs MiniExcel
NPOI vs MiniExcel
ClosedXML vs Report-From-DocX-HTML-To-PDF-Converter