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

ClosedXML 0.46

Rating:        Based on 3 ratings
Reviewed:  3 reviews
Downloads: 136
Change Set: 63425
Released: Mar 6, 2011
Updated: Mar 7, 2011 by MDeLeon
Dev status: Stable Help Icon

Recommended Download

Application ClosedXML for .Net Framework 4.0
application, 153K, uploaded Mar 7, 2011 - 83 downloads

Other Available Downloads

Application ClosedXML for .Net Framework 3.5
application, 153K, uploaded Mar 7, 2011 - 53 downloads

Release Notes

New on this release:

1) Added methods/properties to the worksheets:

worksheet.Hide()
worksheet.Unhide()
worksheet.Visibility

2) If a cell A references another cell B then cellA.Value will return the value of cellB

3) When inserting a DataTable ClosedXML will take the columns captions (if available) and use it as headers. If no caption is available then the column name will be used. Thanks to nitzzzu for the suggestion.

4) You can now set data validations to multiple ranges in one shot via .Ranges(...).DataValidation.

New Examples
Hide Worksheets

Reviews for this release

     
This project saved me a tremendous amount of time while under a severe budget constraint. The developer responded quickly to a modest change request, and releases upgrades regularly. It's well worth a try!
by kbrimington on Mar 12, 2011 at 1:00 AM
     
"If a cell A references another cell B then cellA.Value will return the value of cellB" seems to have hosed my code. I copied a range from Sheet1 to Sheet2 via worksheet.Cell(cellInSheet2.Address).Value = rangeInSheet1; I then updated cellInSheet2 and the value for the same cell in Sheet1 also changed. Is there a workaround to this problem?
by southrnprogrmmr on Mar 7, 2011 at 11:51 PM
     
Found a bug where the first sheet can not be hidden, Ranges().DataValidation works perfectly, thank you!! =)
by Campell on Mar 7, 2011 at 8:33 AM