ClosedXML 0.68.1

Rating:        Based on 15 ratings
Reviewed:  13 reviews
Downloads: 13419
Change Set: 77184
Released: Oct 19, 2012
Updated: Oct 20, 2012 by MDeLeon
Dev status: Stable Help Icon

Recommended Download

Application ClosedXML for .Net Framework 4.0
application, 302K, uploaded Oct 20, 2012 - 10712 downloads

Other Available Downloads

Application ClosedXML for .Net Framework 3.5
application, 301K, uploaded Oct 20, 2012 - 2707 downloads

Release Notes

ClosedXML now resolves formulas!

Yes it finally happened. If you call cell.Value and it has a formula the library will try to evaluate the formula and give you the result.

For example:

            var wb = new XLWorkbook();
            var ws = wb.AddWorksheet("Sheet1");
            ws.Cell("A1").SetValue(1).CellBelow().SetValue(1);
            ws.Cell("B1").SetValue(1).CellBelow().SetValue(1);

            ws.Cell("C1").FormulaA1 = "\"The total value is: \" & SUM(A1:B2)";

            var r = ws.Cell("C1").Value;
            Assert.AreEqual("The total value is: 4", r.ToString());

You can even resolve your own formulas without using cells. For Example:

If you're not referencing a worksheet you can use:
  var sum = XLWorkbook.EvaluateExpr("SUM(1,2,3)");
  // sum = 6
  // SUM(Sheet1!A1:B2) will fail because it doesn't know which workbook to use


If you're not referencing a range without a worksheet you can use:
  var sum = workbook.Evaluate("SUM(Sheet1!A1:B2)");
  // SUM(A1:B2) will fail because it doesn't know which sheet to use


If you have the worksheet you can evaluate at your heart's content:
  var sum = worksheet.Evaluate("SUM(A1:B2)");

This is a list of the included formulas:

All math and trigonometric formulas.
All text formulas except BAHTTEXT, JIS, and PHONETIC.
All logical formulas.
All date and time formulas.
Many statistical formulas.

Very important:

  • Not all formulas are included and you'll probably get a nasty error if the formula isn't supported or if there's an error in the formula. Please test your formulas before going to production.
  • I'm adding new formulas all the time but if your formula isn't included please let me know via the Issue Tracker. I'll do my best to include the formula asap.

As always many fixes and performance improvements

v0.68.1
  • Added all date and time functions

Reviews for this release

     
I'm using it for something really small and simple right now, and this library helped me keep it small and simple. Great stuff!
by ajh1138 on Aug 9, 2013 at 8:37 PM
     
Best library and very easy to use! Thank you.
by onlyutkarsh on May 7, 2013 at 9:59 AM
     
Excelent library, awesome work! Keep it going. Thanks ;)
by Rynkadink on Mar 18, 2013 at 10:59 AM
     
Great Library, Easy to Use,,,
by rikkymayanto on Feb 27, 2013 at 7:19 AM
     
Easy to use and works as expected. Just what I needed when I needed it! Thanks NuGet!
by steven212121 on Feb 26, 2013 at 8:32 PM
     
Excellent library. Thank you very much.
by dynamikus on Feb 14, 2013 at 2:06 PM
     
This library is way too easy to use, it should be illegal.
by SmokingGnu on Jan 25, 2013 at 6:58 AM
     
Extremely useful, easy-to-use, well documented (with a lot of examples and pictures). A big relief after using old Interop, plain OpenXML or SimpleXML. Well done, guys, thank you!
by rlaci on Jan 11, 2013 at 2:01 PM
     
Great library, thank you!
by darkthread on Dec 27, 2012 at 11:58 PM
     
Very easy to use.... Thanks
by askdd on Dec 17, 2012 at 4:28 PM
     
A good library. Makes work so easy!
by Smons on Dec 5, 2012 at 2:37 AM
     
An excellent library, I've done in 10 minutes what I made in weeks directly with OpenDocument libs, tougth, it didn't worked. So this one really help me out. Thanks
by Azaret on Nov 30, 2012 at 10:00 AM
     
this is very good. very easy to use and powerful. you can use it simply and without any document ion reading and error goggling! thanks much
by mostafahk on Nov 29, 2012 at 11:23 AM