ClosedXML 0.43

Rating: No reviews yet
Downloads: 136
Change Set: 61370
Released: Jan 23, 2011
Updated: Jan 24, 2011 by MDeLeon
Dev status: Stable Help Icon

Recommended Download

Application ClosedXML for .Net Framework 4.0
application, 143K, uploaded Jan 24, 2011 - 73 downloads

Other Available Downloads

Application ClosedXML for .Net Framework 3.5
application, 142K, uploaded Jan 24, 2011 - 63 downloads

Release Notes

Breaking Change !!

Removed SheetIndex from the worksheets, please use worksheet.Position instead.
workbook.Worksheet(Int32 index) with workbook.Worksheet(Int32 position)
workbook.Worksheets.Worksheet(Int32 index) with workbook.Worksheets.Worksheet(Int32 position)

If you're using any of these two methods, please update your code accordingly (add 1 to the index to get the position).

The reasoning behind this change is that when you want to retrieve a worksheet it is far more natural to retrieve it by it's position on the workbook than a collection index (which may not be guaranteed to map to a position). A new user will be 100% sure of what worksheet he/she is retrieving if the API says "You're retrieving the worksheet on position X". The same cannot be said of an index, it leaves the user guessing.

I try my best to desing this API as naturally as possible but sometimes I don't have the clarity that hindsight provides. Unfortunately this is where breaking changes occur. This change may seem trivial and not worth the effort but it undoubtedly makes the interface more intuitive.

New on this release:

1) Fixed issues 6138 (error loading shared formulas), 6139 (Custom Properties and Shared Strings)

2) Added method workbook.GetSharedStrings() which returns the list of strings which will be shared in the workbook. Most users won't ever need to use this feature.

3) Added Boolean property cell/range .ShareString with a default value of true. If set to false the cell's text will not be shared and stored as an inline value. Most users won't ever need to use this feature.

4) Copying a worksheet also copies Table definitions, NamedRanges, PageSetup, Outlines, etc.

5) Fixed issue with tables of the same name.

6) Implemented custom properties via workbook.CustomProperties and workbook.CustomProperty(name)
See Workbook Properties

7) Added method cell.InsertData(collection) which returns a range that contains the data. See Inserting Data

8) Added method cell.InsertTable(collection) which returns a table that contains the data. See Inserting Tables

Note: The difference between InsertData and InsertTable is that InsertData doesn't insert column names and returns a range. InsertTable will insert the column names and returns a table.

New Examples
Inserting Tables
Inserting Data

Modified Examples:
Data Types
Workbook Properties
Organizing Sheets

Reviews for this release

No reviews yet for this release.