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).
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" />
paket add ClosedXML --version 0.87.1
#r "nuget: ClosedXML, 0.87.1"
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
Dependencies
-
.NETFramework 3.5
- DocumentFormat.OpenXml (>= 1.0.0)
-
.NETFramework 4.0
- DocumentFormat.OpenXml (>= 2.5.0)
Used By
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 |