ClosedXML 0.93.0
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 VisualBasic.NET.
See the version list below for details.
Install-Package ClosedXML -Version 0.93.0
dotnet add package ClosedXML --version 0.93.0
<PackageReference Include="ClosedXML" Version="0.93.0" />
paket add ClosedXML --version 0.93.0
#r "nuget: ClosedXML, 0.93.0"
Notes
- Big internal refactoring to reduce memory consumption.
- Pivot tables with tables as data sources are now supported. Previously these pivot tables were ignored. They are now parsed and can be manipulated. Please note that there are still unsupported pivot table features, e.g. calculated fields. These unsupported features might now be triggered for pivot tables with table data sources.
Gratitude
A big thank you to @pankraty for the work he's done on implementing the style and range repositories.
Breaking changes:
- Workbook calculation will now use cached results. Call
IXLWorkbook.RecalculateAllFormulas
if you get unexpected results. IXLCell.ValueCached
is now obsolete. UseIXLCell.CachedValue
rather.- Default table theme changed to
TableStyleMedium2
(as Excel does) XLAddress
andXLRangeAddress
is now immutable. Usews.Cell(.., ..).Address
andws.Range(..).RangeAddress
to get instances.IDisposable
interface removed from many classes, e.g fromIXLRange
.- Extension methods now internal. The full list of extension methods that were removed, can be found at here . If you used them, please find alternatives, e.g. morelinq for the
.ForEach
method. - Setting a cell value using
.SetValue()
to a date that's lower than the base date will throw anArgumentException
. - Disallow negative row or column count to be inserted
- Conditional formats applied to multiple ranges are not split into multiple
IXLConditionalFormat
instances. Use the newIXLConditionalFormat.Ranges)
(plural) method to retrieve all ranges.IXLConditionalFormat.Range
(singular) will return only the first range. - This package is now unsigned (no strong name). Use the
ClosedXML.Signed
NuGet package for the signed version.
Notes
- Big internal refactoring to reduce memory consumption.
- Pivot tables with tables as data sources are now supported. Previously these pivot tables were ignored. They are now parsed and can be manipulated. Please note that there are still unsupported pivot table features, e.g. calculated fields. These unsupported features might now be triggered for pivot tables with table data sources.
Gratitude
A big thank you to @pankraty for the work he's done on implementing the style and range repositories.
Breaking changes:
- Workbook calculation will now use cached results. Call
IXLWorkbook.RecalculateAllFormulas
if you get unexpected results. IXLCell.ValueCached
is now obsolete. UseIXLCell.CachedValue
rather.- Default table theme changed to
TableStyleMedium2
(as Excel does) XLAddress
andXLRangeAddress
is now immutable. Usews.Cell(.., ..).Address
andws.Range(..).RangeAddress
to get instances.IDisposable
interface removed from many classes, e.g fromIXLRange
.- Extension methods now internal. The full list of extension methods that were removed, can be found at here . If you used them, please find alternatives, e.g. morelinq for the
.ForEach
method. - Setting a cell value using
.SetValue()
to a date that's lower than the base date will throw anArgumentException
. - Disallow negative row or column count to be inserted
- Conditional formats applied to multiple ranges are not split into multiple
IXLConditionalFormat
instances. Use the newIXLConditionalFormat.Ranges)
(plural) method to retrieve all ranges.IXLConditionalFormat.Range
(singular) will return only the first range. - This package is now unsigned (no strong name). Use the
ClosedXML.Signed
NuGet package for the signed version.
Release Notes
See https://github.com/ClosedXML/ClosedXML/releases/tag/0.93.0
Dependencies
-
.NETFramework 4.0
- DocumentFormat.OpenXml (>= 2.7.2)
- ExcelNumberFormat (>= 1.0.3)
- FastMember.Signed (>= 1.3.0)
-
.NETFramework 4.6
- DocumentFormat.OpenXml (>= 2.7.2)
- ExcelNumberFormat (>= 1.0.3)
- FastMember.Signed (>= 1.3.0)
-
.NETStandard 2.0
- DocumentFormat.OpenXml (>= 2.7.2)
- ExcelNumberFormat (>= 1.0.3)
- FastMember.Signed (>= 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 | 227,998 | 12/16/2020 |
0.95.3 | 1,261,564 | 5/25/2020 |
0.95.2 | 190,133 | 4/26/2020 |
0.95.1 | 20,437 | 4/23/2020 |
0.95.0 | 74,774 | 4/15/2020 |
0.95.0-beta2 | 48,842 | 8/21/2019 |
0.95.0-beta1 | 21,177 | 4/4/2019 |
0.94.2 | 2,550,488 | 12/18/2018 |
0.94.0 | 32,364 | 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,966 | 8/7/2018 |
0.93.0 | 183,646 | 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,709 | 4/10/2018 |
0.92.0-beta1 | 3,646 | 3/22/2018 |
0.91.1 | 24,205 | 4/4/2018 |
0.91.0 | 175,395 | 1/31/2018 |
0.91.0-beta3 | 1,965 | 1/23/2018 |
0.91.0-beta2 | 10,689 | 12/8/2017 |
0.91.0-beta1 | 1,754 | 11/29/2017 |
0.90.0 | 395,848 | 10/23/2017 |
0.90.0-beta2 | 2,048 | 10/6/2017 |
0.89.0 | 240,550 | 9/12/2017 |
0.89.0-beta1 | 3,452 | 8/23/2017 |
0.88.0 | 124,542 | 7/24/2017 |
0.88.0-beta1 | 6,428 | 7/10/2017 |
0.87.1 | 580,301 | 4/3/2017 |
0.86.0 | 220,407 | 1/6/2017 |
0.85.0 | 142,576 | 12/7/2016 |
0.80.1 | 260,457 | 9/15/2016 |
0.76.0 | 1,002,692 | 12/16/2014 |
0.75.0 | 103,370 | 9/17/2014 |
0.74.0 | 26,872 | 8/10/2014 |
0.73.0 | 29,735 | 6/24/2014 |
0.72.3 | 11,018 | 6/4/2014 |
0.72.2 | 1,690 | 6/4/2014 |
0.72.1 | 29,361 | 6/4/2014 |
0.72.0 | 3,992 | 6/4/2014 |
0.71.1 | 9,532 | 5/26/2014 |
0.70.0 | 5,042 | 5/18/2014 |
0.69.2 | 104,815 | 10/3/2013 |
0.69.1 | 25,831 | 8/15/2013 |
0.69.0 | 3,172 | 8/10/2013 |
0.68.1 | 54,994 | 10/20/2012 |
0.68.0 | 2,483 | 10/12/2012 |
0.67.2 | 12,513 | 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 |