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.
#r "nuget: ClosedXML, 0.87.1"
For F# scripts that support #r syntax, copy this into the source code to reference the package.

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

NuGet packages (124)

Showing the top 5 NuGet packages that depend on ClosedXML:

Package Downloads
CsvHelper.Excel
An implementation of ICsvParser and ICsvSerializer from CsvHelper that reads and writes using the ClosedXml library.
Ewl
The Enterprise Web Library (EWL), and its tailored infrastructure platform, are a complete and open solution for developing and operating web-based enterprise software.
DoddleReport.OpenXml
Adds OpenXML support to DoddleReport. The currently supported format is Excel and is more robust than the default ExcelReportWriter in DoddleReport.
ClosedXML.Extensions.Mvc
MVC extensions for ClosedXML
ClosedXML.Report
ClosedXML.Report is a tool for report generation and data analysis in .NET applications through the use of Microsoft Excel. ClosedXML.Report is a .NET-library for report generation Microsoft Excel without requiring Excel to be installed on the machine that's running the code.

GitHub repositories (6)

Showing the top 5 popular GitHub repositories that depend on ClosedXML:

Repository Stars
open-rpa/openrpa
Free Open Source Enterprise Grade RPA
Implem/Implem.Pleasanter
Pleasanter | Business application platform
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.
nhmkdev/cardmaker
An application that generates graphics via data sources.
matthidinger/DoddleReport
Generate custom reports (PDF, Excel, etc) from any IEnumerable datasource.

Version History

Version Downloads Last updated
0.95.4 233,558 12/16/2020
0.95.3 1,268,452 5/25/2020
0.95.2 190,931 4/26/2020
0.95.1 20,725 4/23/2020
0.95.0 75,035 4/15/2020
0.95.0-beta2 48,879 8/21/2019
0.95.0-beta1 21,187 4/4/2019
0.94.2 2,555,280 12/18/2018
0.94.0 32,387 12/12/2018
0.94.0-rc2 4,013 11/29/2018
0.94.0-rc1 5,136 11/11/2018
0.93.1 546,673 8/7/2018
0.93.0 183,866 6/25/2018
0.93.0-rc3 6,656 6/7/2018
0.93.0-rc2 2,408 5/31/2018
0.93.0-beta4 3,383 5/14/2018
0.93.0-beta2 3,825 4/26/2018
0.93.0-beta1 1,711 4/19/2018
0.92.1 339,552 4/10/2018
0.92.0-beta1 3,661 3/22/2018
0.91.1 24,249 4/4/2018
0.91.0 175,597 1/31/2018
0.91.0-beta3 1,981 1/23/2018
0.91.0-beta2 10,692 12/8/2017
0.91.0-beta1 1,757 11/29/2017
0.90.0 396,296 10/23/2017
0.90.0-beta2 2,049 10/6/2017
0.89.0 240,711 9/12/2017
0.89.0-beta1 3,453 8/23/2017
0.88.0 124,636 7/24/2017
0.88.0-beta1 6,453 7/10/2017
0.87.1 580,985 4/3/2017
0.86.0 220,665 1/6/2017
0.85.0 142,714 12/7/2016
0.80.1 261,430 9/15/2016
0.76.0 1,003,129 12/16/2014
0.75.0 103,491 9/17/2014
0.74.0 26,874 8/10/2014
0.73.0 29,746 6/24/2014
0.72.3 11,025 6/4/2014
0.72.2 1,690 6/4/2014
0.72.1 29,408 6/4/2014
0.72.0 4,007 6/4/2014
0.71.1 9,537 5/26/2014
0.70.0 5,057 5/18/2014
0.69.2 104,828 10/3/2013
0.69.1 25,858 8/15/2013
0.69.0 3,174 8/10/2013
0.68.1 55,021 10/20/2012
0.68.0 2,485 10/12/2012
0.67.2 12,521 8/14/2012
0.67.1 1,724 8/13/2012
0.67.0 1,754 8/12/2012
0.66.1 2,365 7/28/2012
0.66.0 1,979 7/18/2012
0.65.2 4,273 4/21/2012
0.64.0 4,651 2/4/2012
Show less