XlsxSharp 1.0.0

XlsxSharp 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.

This is a fork of ClosedXML. With the primary goal to update the library to .NET 10 and to maintain it with the latest .NET versions.

For more information see the documentation.

Install XlsxSharp via NuGet

If you want to include XlsxSharp in your project, you can install it directly from NuGet

XlsxSharp is currently published as a prerelease, so the prerelease switch is required. To install XlsxSharp, run the following command in the Package Manager Console

PM> Install-Package XlsxSharp -IncludePrerelease

What can you do with this?

XlsxSharp allows you to create Excel files without the Excel application. The typical example is creating Excel reports on a web server.

Example:

using (var workbook = new XLWorkbook())
{
    var worksheet = workbook.Worksheets.Add("Sample Sheet");
    worksheet.Cell("A1").Value = "Hello World!";
    worksheet.Cell("A2").FormulaA1 = "=MID(A1, 7, 5)";
    workbook.SaveAs("HelloWorld.xlsx");
}

Formula parser

XlsxSharp ships its own Pratt (operator-precedence) formula parser (XlsxSharp.Parser), supporting both A1 and R1C1 reference styles. It is regression-tested against real-world formula corpora, most notably the Enron and EUSES spreadsheet datasets used in academic formula-parsing research:

These figures are asserted as a floor in XlsxSharp.Parser.Tests/PrattDataSetTests.cs (EnronDataSetCoverage, EusesDataSetCoverage), so any regression in parser coverage fails CI.

Developer guidelines

The OpenXML specification is a large and complicated beast. In order for XlsxSharp, the wrapper around OpenXML, to support all the features, we rely on community contributions. Before opening an issue to request a new feature, we'd like to urge you to try to implement it yourself and log a pull request.

Please read the full developer guidelines.

Credits

• Project originally created by Manuel de Leon
• Current maintainer: Stefan Nikolei
• Former maintainer: Jan Havlíček
• Former maintainer and lead developer: Francois Botha
• Master of Computing Patterns: Aleksei Pankratev