ClosedXML 0.26

Rating: No reviews yet
Downloads: 55
Change Set: 57667
Released: Oct 25, 2010
Updated: Oct 26, 2010 by MDeLeon
Dev status: Stable Help Icon

Recommended Download

Application ClosedXML.dll
application, 161K, uploaded Oct 26, 2010 - 55 downloads

Release Notes

This release took longer than expected because I had to refactor the way I was handling rows, columns, and ranges.

New on this release:

1) Inserting rows/columns to worksheets/ranges will shift existing referenced ranges accordingly.

For example:
var rngTitles = worksheet.Range("B2:D2");
Console.Write(rngTitles.ToString()); // Prints "B4:D4" because the entire range moved down 2 rows.

See examples Inserting and Deleting Rows and Inserting and Deleting Columns

2) Added a DateFormat to the styles. It does the same function as Style.NumberFormat but it will be more intuitive for

someone trying to format a date.

So instead of doing:
rngDates.Style.NumberFormat.Format = "MM/dd/yyyy";

You can now do:
rngDates.Style.DateFormat.Format = "MM/dd/yyyy";

3) Modified IXLRange to have the "IXLRanges Ranges(...)" methods. IXLRanges is a collection of ranges which allow you to

modify them all in one shot.

See example Multiple Ranges

4) Worksheet.Style, Worksheet.Columns(), and Worksheet.Rows() now apply to the entire worksheet (not just the used cells).

For example:

worksheet.Style.Fill.BackgroundColor = Color.Blue; // Will turn every cell blue
worksheet.Columns().Style.Fill.BackgroundColor = Color.Blue; // Will do the same (turn every cell blue)
worksheet.Rows().Style.Fill.BackgroundColor = Color.Blue; // Will do the same (turn every cell blue)

worksheet.Columns().Width = 30; // Will set the width of every column to 30
worksheet.Rows().Height = 15; // Will set the height of every row to 15

See examples Style Worksheet and Style Rows and Columns

5) Miscelaneous:

Fixed a bug in the Saving function.
Fixed inserting an entire row/column to a worksheet (now that we're supporting entire worksheets/rows/columns)

New Examples:
Multiple Ranges
Style Worksheet
Style Rows and Columns
Inserting Rows
Inserting and Deleting Rows
Inserting Columns
Inserting and Deleting Columns

Examples changed:
Data Types
Loading and Modifying Files
Headers and Footers Tab

Examples removed
Inserting Rows and Columns

Reviews for this release

No reviews yet for this release.