ClosedXML 0.93.0-rc2
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-rc2
dotnet add package ClosedXML --version 0.93.0-rc2
<PackageReference Include="ClosedXML" Version="0.93.0-rc2" />
paket add ClosedXML --version 0.93.0-rc2
#r "nuget: ClosedXML, 0.93.0-rc2"
Notes
- Big internal refactoring to reduce memory consumption.
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.
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-rc2
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 |