618,350

Downloads

44,202

Downloads of v 0.87.1

280

Average downloads per day

2017-04-03

Last published

Share on Social Networks

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).

To install ClosedXML, run the following command in the Package Manager Console

Install-Package ClosedXML -Version 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

Owners

Authors

Amir Ghezelbash, Francois Botha, Manuel De Leon

Copyright

@ClosedXML

Dependencies

Version History

Version Downloads Last updated
ClosedXML 0.87.1 (this version) 44,202 Monday, April 3, 2017
ClosedXML 0.86.0 53,743 Friday, January 6, 2017
ClosedXML 0.85.0 22,281 Wednesday, December 7, 2016
ClosedXML 0.80.1 53,050 Thursday, September 15, 2016
ClosedXML 0.76.0 278,828 Tuesday, December 16, 2014
ClosedXML 0.75.0 42,027 Wednesday, September 17, 2014
ClosedXML 0.74.0 18,553 Sunday, August 10, 2014
ClosedXML 0.73.0 7,893 Tuesday, June 24, 2014
ClosedXML 0.72.3 4,568 Wednesday, June 4, 2014
ClosedXML 0.72.2 222 Wednesday, June 4, 2014
ClosedXML 0.72.1 1,708 Wednesday, June 4, 2014
ClosedXML 0.72.0 1,283 Wednesday, June 4, 2014
ClosedXML 0.71.1 2,114 Monday, May 26, 2014
ClosedXML 0.70.0 2,470 Sunday, May 18, 2014
ClosedXML 0.69.2 35,342 Thursday, October 3, 2013
ClosedXML 0.69.1 8,639 Thursday, August 15, 2013
ClosedXML 0.69.0 453 Saturday, August 10, 2013
ClosedXML 0.68.1 27,701 Saturday, October 20, 2012
ClosedXML 0.68.0 440 Friday, October 12, 2012
ClosedXML 0.67.2 6,355 Tuesday, August 14, 2012
ClosedXML 0.67.1 284 Monday, August 13, 2012
ClosedXML 0.67.0 299 Sunday, August 12, 2012
ClosedXML 0.66.1 924 Saturday, July 28, 2012
ClosedXML 0.66.0 458 Wednesday, July 18, 2012
ClosedXML 0.65.2 1,658 Saturday, April 21, 2012
ClosedXML 0.64.0 1,312 Saturday, February 4, 2012