ClosedXML 0.87.1

ClosedXML makes it easier for developers to create Excel 2007+ (.xlsx, .xlsm, etc) files. It provides a nice object oriented way to manipulate the files (similar to VBA) without dealing with the hassles of XML Documents. It can be used by any .NET language like C# and Visual Basic (VB).

There is a newer version of this package available.
See the version list below for details.
Install-Package ClosedXML -Version 0.87.1
dotnet add package ClosedXML --version 0.87.1
<PackageReference Include="ClosedXML" Version="0.87.1" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add ClosedXML --version 0.87.1
The NuGet Team does not provide support for this client. Please contact its maintainers for support.

Release Notes

#148 Improve conditional formatting loading and saving
#149 Update test for correctly testing time value as string
#154 Shift page breaks
#157 Fix maths / statistical functions
#158 Explicitly ignore custom sheet view elements.
#159 Force OpenXMLValidator to run under invariant culture
#172 Allow pivot table field to be a value field and a row/column/filter
#173 Cap column width at 255
#179 Pivot table loading enhancements and collapsing fields
#180 Implement sheet zooming
#185 Correctly deduce data type from number format string if data type i
#186 Deduce default header and footer font from worksheet
#199 Classic layout should be disabled by default.
#200 Preserve whitespace in cells.
#203 Remove orphaned drawings from worksheets
#204 Better detection of numerical data types. Not only System.Double.
#212 Preserve cell format when inserting table or data
#214 Don't reference cell to get row height
#222 Add VmlDrawing Id's to context to avoid reuse.
#231 Text() function - return string as is if input value is already a s
#232 Column.AdjustToContents(): Inspect worksheet and table autofilters
#233 Don't crash when file contains multiple default styles

Showing the top 3 GitHub repositories that depend on ClosedXML:

Repository Stars
Implem/Implem.Pleasanter
Pleasanter | Business application platform
matthidinger/DoddleReport
Generate custom reports (PDF, Excel, etc) from any IEnumerable datasource.
ClosedXML/ClosedXML.Report
ClosedXML.Report is a tool for report generation with which you can easily export any data from your .NET classes to Excel using a XLSX-template.

Version History

Version Downloads Last updated
0.95.0-beta2 4,399 8/21/2019
0.95.0-beta1 9,299 4/4/2019
0.94.2 555,901 12/18/2018
0.94.0 12,651 12/12/2018
0.94.0-rc2 2,476 11/29/2018
0.94.0-rc1 4,182 11/11/2018
0.93.1 307,083 8/7/2018
0.93.0 113,639 6/25/2018
0.93.0-rc3 5,225 6/7/2018
0.93.0-rc2 1,858 5/31/2018
0.93.0-beta4 2,870 5/14/2018
0.93.0-beta2 2,706 4/26/2018
0.93.0-beta1 1,263 4/19/2018
0.92.1 184,406 4/10/2018
0.92.0-beta1 3,068 3/22/2018
0.91.1 10,950 4/4/2018
0.91.0 126,657 1/31/2018
0.91.0-beta3 1,480 1/23/2018
0.91.0-beta2 8,461 12/8/2017
0.91.0-beta1 1,399 11/29/2017
0.90.0 263,671 10/23/2017
0.90.0-beta2 1,687 10/6/2017
0.89.0 171,583 9/12/2017
0.89.0-beta1 1,882 8/23/2017
0.88.0 79,404 7/24/2017
0.88.0-beta1 1,462 7/10/2017
0.87.1 332,875 4/3/2017
0.86.0 157,831 1/6/2017
0.85.0 83,075 12/7/2016
0.80.1 150,031 9/15/2016
0.76.0 685,494 12/16/2014
0.75.0 64,121 9/17/2014
0.74.0 24,397 8/10/2014
0.73.0 21,426 6/24/2014
0.72.3 7,229 6/4/2014
0.72.2 1,300 6/4/2014
0.72.1 7,807 6/4/2014
0.72.0 3,375 6/4/2014
0.71.1 6,387 5/26/2014
0.70.0 4,366 5/18/2014
0.69.2 78,344 10/3/2013
0.69.1 15,090 8/15/2013
0.69.0 1,878 8/10/2013
0.68.1 40,611 10/20/2012
0.68.0 1,765 10/12/2012
0.67.2 10,208 8/14/2012
0.67.1 1,385 8/13/2012
0.67.0 1,357 8/12/2012
0.66.1 2,003 7/28/2012
0.66.0 1,582 7/18/2012
0.65.2 3,382 4/21/2012
0.64.0 3,624 2/4/2012
Show less