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

ClosedXML 0.42.1

Rating:        Based on 1 rating
Reviewed:  1 review
Downloads: 108
Change Set: 61259
Released: Jan 18, 2011
Updated: Jan 21, 2011 by MDeLeon
Dev status: Stable Help Icon


Application ClosedXML for .Net Framework 4.0
application, 139K, uploaded Jan 21, 2011 - 60 downloads
Application ClosedXML for .Net Framework 3.5
application, 139K, uploaded Jan 21, 2011 - 48 downloads

Release Notes

New on this release:

1) Added the following methods to the worksheets:

IXLWorksheet CopyTo(String newSheetName);
IXLWorksheet CopyTo(String newSheetName, Int32 position);
IXLWorksheet CopyTo(XLWorkbook workbook, String newSheetName);
IXLWorksheet CopyTo(XLWorkbook workbook, String newSheetName, Int32 position);

See example Copying Worksheets

2) Added property worksheet.Position to set the position of the worksheets. This is the same as setting the SheetIndex but the positions start at 1 instead of zero for the SheetIndexes. I added this because when you're reordering the worksheets it feels a lot more natural to set a "Position" than an index.

3) Added overload Worksheets.Add(String sheetName, Int32 position). This way you can add a worksheet in a specific position in one shot.

4) Added method range.RangeUsed(), which is equivalent to range.Range(range.FirstCellUsed(), range.LastCellUsed())

5) Added method workbook.Worksheet(String/Int32) to retrieve existing worksheets. I can't believe it never occured to me to add this before.

6) Improved overall performance.

7) Fixed Issue # 6807

8) Reduced the size of the generated files.

New on v0.42.1

1) Fixed formatting issue with non-US locale

New Examples
Copying Worksheets

Reviews for this release

superb job! thanks
by smnbss on Jan 19, 2011 at 8:47 AM