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

ClosedXML 0.24

Rating: No reviews yet
Downloads: 54
Change Set: 56085
Released: Sep 23, 2010
Updated: Sep 24, 2010 by MDeLeon
Dev status: Stable Help Icon

Recommended Download

Application ClosedXML.dll
application, 127K, uploaded Sep 24, 2010 - 54 downloads

Release Notes

New on this release:

1) Implemented a more natural way to deal with multiple rows/columns/ranges

With the old method you were forced to iterate through every item like this:
foreach(var c in worksheet.Columns("G:H"))
{
     c.Style.Fill.BackgroundColor = Color.Blue;
}

With the new method you can still iterate using the foreach loop but you can also do the following more natural and shorter thing:
worksheet.Columns("G:H").Style.Fill.BackgroundColor = Color.Blue;

Breaking changes:

1) Modified the way to add print areas to a more natural and safe way:

The old method forced you to create a new range (btw, which could be in a whole other sheet), like so:
ws.PageSetup.PrintAreas.Add(ws.Range("A1:B2"));

The new method only allows you to specify a range pertaining to the worksheet (with the usual overloads for specifying a range), like so:
ws.PageSetup.PrintAreas.Add("A1:B2");

2) Made it more natural and safe to specify the rows to repeat at top and columns to repeat at left

The old method required you to specify a range (btw, which could be in a whole other sheet), plus the name wasn't very intuitive:
ws.PageSetup.SetRowTitles(ws.Rows(1, 2));

The new method has a much more intuitive name and it's less prone to errors:
ws.PageSetup.SetRowsToRepeatAtTop(1,2);

3) Made it more natural and intuitive to add vertical and horizontal page breaks.

The old method forced you to create a new row or column(btw, which could be in a whole other sheet), like so:
ws.PageSetup.AddPageBreak(ws2.Row(2));
ws.PageSetup.AddPageBreak(ws2.Column(2));

The new method has a much more intuitive name and it's less prone to errors:
ws.PageSetup.AddHorizontalPageBreak(2);
ws.PageSetup.AddVerticalPageBreak(2);

Examples changed:

Selecting Columns
Selecting Rows
Sheet Tab
Print Areas and Page Breaks

Reviews for this release

No reviews yet for this release.