ClosedXML 0.95.0-beta1

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.

This is a prerelease version of ClosedXML.
There is a newer version of this package available.
See the version list below for details.
Install-Package ClosedXML -Version 0.95.0-beta1
dotnet add package ClosedXML --version 0.95.0-beta1
<PackageReference Include="ClosedXML" Version="0.95.0-beta1" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add ClosedXML --version 0.95.0-beta1
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
#r "nuget: ClosedXML, 0.95.0-beta1"
For F# scripts that support #r syntax, copy this into the source code to reference the package.

Breaking changes

  • Range strings, e.g. A1:B2 are now always treated as absolute, i.e. relative to A1 instead of relative to the top left cell of a given range.
  • IXLSheetProtection has been totally refactored and now uses a flag based enum to control the elements that are allowed or locked.
  • Removed IXLSheetProtection.IsProtected setter
  • XLClearOptions and XLCellUsedOptions 's flags are now aligned

Enhancements

  • #1015 Text join func enhancement (Thanks @James-Whitfield)
  • #1038 IXLSheetProtection refactoring
  • #1054 Implement workbook FileSharing and a few of the properties
  • #1058 Dont recalculate formula cached values after load
  • #1077 Refactor digit and letter parsing to allow Unicode characters
  • #1109 Don't automatically adjust columns width to contents when inserting datatable. Some users want to opt out because of PlatformNotSupportedException
  • #1129 Implementation pivot table formats (Thanks @b0bi79)
  • #1130 Enhance TRUNC function for additional parameter
  • #1136 Implement NUMBERVALUE function
  • #1151 Performance improvement to delete entire columns
  • #1158 Check that print titles are valid row ranges or column ranges
  • #1170 Remove IXLSheetProtection.IsProtected public setter

Bug fixes

  • #1063 Copy comment style correctly when shifting ranges
  • #1108 Correctly save empty cell with quote prefix (do not treat as empty)
  • #1132 <c> elements with missing r attribute: XLAddress constructor had parameters swapped
  • #1133 Enumerate ranges in a deterministic order
  • #1134 Correctly propagate worksheet style to cells from a worksheet
  • #1135 Correctly load column-wide styles
  • #1137 Fix changing inner borders of the range
  • #1150 Correctly clear inline string when required
  • #1153 Correctly throw DivisionByZeroException when denominator is zero.
  • #1155 Ignore _X (capital X) as XML escaping char
  • #1161 Avoid creation of new item in Internals.RowsCollection when adding comment
  • #1168 Fix initialization of default styles for XLCells, XLRows, XLColumns and XLRanges

Thanks to @Pankraty for many PRs, as usual.

  • @igitur

Breaking changes

  • Range strings, e.g. A1:B2 are now always treated as absolute, i.e. relative to A1 instead of relative to the top left cell of a given range.
  • IXLSheetProtection has been totally refactored and now uses a flag based enum to control the elements that are allowed or locked.
  • Removed IXLSheetProtection.IsProtected setter
  • XLClearOptions and XLCellUsedOptions 's flags are now aligned

Enhancements

  • #1015 Text join func enhancement (Thanks @James-Whitfield)
  • #1038 IXLSheetProtection refactoring
  • #1054 Implement workbook FileSharing and a few of the properties
  • #1058 Dont recalculate formula cached values after load
  • #1077 Refactor digit and letter parsing to allow Unicode characters
  • #1109 Don't automatically adjust columns width to contents when inserting datatable. Some users want to opt out because of PlatformNotSupportedException
  • #1129 Implementation pivot table formats (Thanks @b0bi79)
  • #1130 Enhance TRUNC function for additional parameter
  • #1136 Implement NUMBERVALUE function
  • #1151 Performance improvement to delete entire columns
  • #1158 Check that print titles are valid row ranges or column ranges
  • #1170 Remove IXLSheetProtection.IsProtected public setter

Bug fixes

  • #1063 Copy comment style correctly when shifting ranges
  • #1108 Correctly save empty cell with quote prefix (do not treat as empty)
  • #1132 <c> elements with missing r attribute: XLAddress constructor had parameters swapped
  • #1133 Enumerate ranges in a deterministic order
  • #1134 Correctly propagate worksheet style to cells from a worksheet
  • #1135 Correctly load column-wide styles
  • #1137 Fix changing inner borders of the range
  • #1150 Correctly clear inline string when required
  • #1153 Correctly throw DivisionByZeroException when denominator is zero.
  • #1155 Ignore _X (capital X) as XML escaping char
  • #1161 Avoid creation of new item in Internals.RowsCollection when adding comment
  • #1168 Fix initialization of default styles for XLCells, XLRows, XLColumns and XLRanges

Thanks to @Pankraty for many PRs, as usual.

  • @igitur

Release Notes

See https://github.com/ClosedXML/ClosedXML/releases/tag/0.95.0-beta1

NuGet packages (123)

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 224,563 12/16/2020
0.95.3 1,257,707 5/25/2020
0.95.2 189,745 4/26/2020
0.95.1 20,313 4/23/2020
0.95.0 74,542 4/15/2020
0.95.0-beta2 48,810 8/21/2019
0.95.0-beta1 21,166 4/4/2019
0.94.2 2,547,865 12/18/2018
0.94.0 32,311 12/12/2018
0.94.0-rc2 4,013 11/29/2018
0.94.0-rc1 5,134 11/11/2018
0.93.1 545,560 8/7/2018
0.93.0 183,534 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,366 5/14/2018
0.93.0-beta2 3,825 4/26/2018
0.93.0-beta1 1,711 4/19/2018
0.92.1 338,512 4/10/2018
0.92.0-beta1 3,646 3/22/2018
0.91.1 24,196 4/4/2018
0.91.0 175,296 1/31/2018
0.91.0-beta3 1,964 1/23/2018
0.91.0-beta2 10,688 12/8/2017
0.91.0-beta1 1,753 11/29/2017
0.90.0 395,633 10/23/2017
0.90.0-beta2 2,048 10/6/2017
0.89.0 240,480 9/12/2017
0.89.0-beta1 3,451 8/23/2017
0.88.0 124,424 7/24/2017
0.88.0-beta1 6,387 7/10/2017
0.87.1 579,970 4/3/2017
0.86.0 220,321 1/6/2017
0.85.0 142,480 12/7/2016
0.80.1 260,093 9/15/2016
0.76.0 1,001,869 12/16/2014
0.75.0 103,287 9/17/2014
0.74.0 26,871 8/10/2014
0.73.0 29,730 6/24/2014
0.72.3 11,014 6/4/2014
0.72.2 1,690 6/4/2014
0.72.1 29,308 6/4/2014
0.72.0 3,992 6/4/2014
0.71.1 9,532 5/26/2014
0.70.0 5,030 5/18/2014
0.69.2 104,799 10/3/2013
0.69.1 25,798 8/15/2013
0.69.0 3,172 8/10/2013
0.68.1 54,970 10/20/2012
0.68.0 2,483 10/12/2012
0.67.2 12,499 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,269 4/21/2012
0.64.0 4,649 2/4/2012
Show less