This project has moved. For the latest updates, please go here.

ClosedXML 0.53.1

Rating: No reviews yet
Downloads: 187
Change Set: 66974
Released: May 25, 2011
Updated: May 25, 2011 by MDeLeon
Dev status: Stable Help Icon

Recommended Download

Application ClosedXML for .Net Framework 4.0
application, 179K, uploaded May 25, 2011 - 118 downloads

Other Available Downloads

Application ClosedXML for .Net Framework 3.5
application, 179K, uploaded May 25, 2011 - 69 downloads

Release Notes

New on this release:

1) Added FindCells, FindColumns, and FindRows methods to the workbook object.

2) Added cell.ValueCached property that holds Excel's cache of formula evaluations.

3) Added the following properties to the worksheets:

ShowFormulas
ShowGridLines
ShowOutlineSymbols
ShowRowColHeaders
ShowRuler
ShowWhiteSpace
ShowZeros

4) Added methods Worksheets.Add(DataTable), Worksheets.Add(DataSet). See examples Adding DataTable as Worksheet, Adding DataSet

5) Fixed issues 6609, 6532, 6510, 6499, 6705, 6508

Breaking Changes:

Removed static method XLWorkbook.GetXLFont(). When you add a header/footer text which you want to format just modify the rich text/font returned by the .AddText(...) methods. See example Headers and Footers Tab

New on v0.53.1

1) Added TabColor property to the worksheets. See example Tab Colors

2) Added overloads to further fine tune how adjust to contents functions work:

IXLColumn AdjustToContents(Double minWidth, Double maxWidth);
IXLColumn AdjustToContents(Int32 startRow, Double minWidth, Double maxWidth);
IXLColumn AdjustToContents(Int32 startRow, Int32 endRow, Double minWidth, Double maxWidth);

IXLRow AdjustToContents(Double minHeight, Double maxHeight);
IXLRow AdjustToContents(Int32 startColumn, Double minHeight, Double maxHeight);
IXLRow AdjustToContents(Int32 startColumn, Int32 endColumn, Double minHeight, Double maxHeight);

3) Fixed issue 6706 (sheet protection)

New Examples
Adding DataTable as Worksheet
Adding DataSet
Tab Colors

Modified Examples:
Headers and Footers Tab

Reviews for this release

No reviews yet for this release.