This project has moved and is read-only. For the latest updates, please go here.

ClosedXML 0.40

Rating: No reviews yet
Downloads: 150
Change Set: 60733
Released: Jan 8, 2011
Updated: Jan 9, 2011 by MDeLeon
Dev status: Stable Help Icon

Recommended Download

Application ClosedXML for .Net Framework 4.0
application, 136K, uploaded Jan 9, 2011 - 84 downloads

Other Available Downloads

Application ClosedXML for .Net Framework 3.5
application, 136K, uploaded Jan 9, 2011 - 66 downloads

Release Notes

New on this release:

1) Added Excel Tables. A bonus is that you can call a cell using the field name instead of the address. See examples Using Tables, Showcase

2) Modified the behavior of range.InsertRows/Columns. When you insert a column after the range or a row below the range, the range will be expanded to include the newly added rows/columns. If you insert a column before the range or a row above the range, the range will move accordingly but not expand. This is the default behavior but the insert rows/columns now have a parameter for you to specify whether or not to expand the range.

3) Added range.ClearStyles() method. It will preserve number/date formats though.

4) Added the following set only properties to .Cells(...)

.Cells(...).Value
.Cells(...).DataType
.Cells(...).FormulaA1
.Cells(...).FormulaR1C1

So now you can do something like: worksheet.Row(1).Cells("1-3,5,7").Value = "Good!";

5) Added the following methods to .Cells(...)
.Cells(...).Clear()
.Cells(...).ClearStyles()

6) Removed the properties range.FormulaA1 and range.FormulaR1C1. Please use range.Cells().FormulaA1 and range.Cells().FormulaR1C1 instead.

7) Improved save performance, A LOT. (Thanks to GFraser for the help locating the bottlenecks)
I still have a few things to do to improve the performance but I wanted to release this version because of the substantial improvements already made.


New Examples
Using Tables
Showcase

Modified Examples:
Using Formulas

Reviews for this release

No reviews yet for this release.