ClosedXML
ClosedXML.Report
| ClosedXML | ClosedXML.Report | |
|---|---|---|
| 26 | 2 | |
| 4,421 | 505 | |
| 3.4% | 2.6% | |
| 9.4 | 4.0 | |
| 3 days ago | 19 days ago | |
| C# | C# | |
| MIT License | MIT License |
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.
ClosedXML
-
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:
https://github.com/ClosedXML/ClosedXML/pull/1899
-
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?
ClosedXML.Report
-
Discovered a NuGet package called ClosedXML. Takes away the pain of dealing with OpenXML
Also shoutout to the report package for exporting classes to spreadhsheets. https://github.com/ClosedXML/ClosedXML.Report
-
LPT: Learn excel. It's one of the most under-appreciated tools within the office environment and rarely used to its full potential
I don't have a comprehensive source, but here is a link to the ClosedXML .NET library.
What are some alternatives?
Open XML SDK - Open XML SDK by Microsoft
QuestPDF - QuestPDF is a modern open-source .NET library for PDF document generation. Offering comprehensive layout engine powered by concise and discoverable C# Fluent API. Easily generate PDF reports, invoices, exports, etc.
EPPlus
ReoGrid - Fast and powerful .NET spreadsheet component, support data format, freeze, outline, formula calculation, chart, script execution and etc. Compatible with Excel 2007 (.xlsx) format and working on .NET 3.5 (or client profile), WPF and Android platform.
NPOI - a .NET library that can read/write Office formats without Microsoft Office installed. No COM+, no interop.
FastReport - Free Open Source Reporting tool for .NET6/.NET Core/.NET Framework that helps your application generate document-like reports
ExcelDataReader - Lightweight and fast library written in C# for reading Microsoft Excel files
programmatically-manage-excel-spreadsheets-with-dotnet - Sample code to create an Excel spreadsheet and manipulate data with dotnet
MiniExcel - Fast, Low-Memory, Easy Excel .NET helper to import/export/template spreadsheet (support Linux, Mac)
extentreports-csharp - Extent Reporting Library, .NET
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