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.
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 toA1
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
andXLCellUsedOptions
'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 missingr
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
andXLRanges
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 toA1
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
andXLCellUsedOptions
'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 missingr
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
andXLRanges
Thanks to @Pankraty for many PRs, as usual.
- @igitur
Release Notes
See https://github.com/ClosedXML/ClosedXML/releases/tag/0.95.0-beta1
Dependencies
-
.NETFramework 4.0
- DocumentFormat.OpenXml (>= 2.7.2)
- ExcelNumberFormat (>= 1.0.3)
- FastMember (>= 1.3.0)
-
.NETFramework 4.6
- DocumentFormat.OpenXml (>= 2.7.2)
- ExcelNumberFormat (>= 1.0.3)
- FastMember (>= 1.3.0)
-
.NETStandard 2.0
- DocumentFormat.OpenXml (>= 2.7.2)
- ExcelNumberFormat (>= 1.0.3)
- FastMember (>= 1.3.0)
- System.Drawing.Common (>= 4.5.0)
Used By
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 |