The ClosedXML package will allow developers to create OpenXML files for Excel 2007. It provides a nice object oriented way to manipulate the files (similar to VBA) without dealing with the hassles of XML Documents. It's developed in C# but can be used by any other .NET language.
ClosedXML allows you to create Excel 2007/2010 files without the Excel application. If you ever used the Microsoft Open XML Format SDK you know just how much code you have to write to get the same results as the following 4 lines of code:
- var workbook = new XLWorkbook("Sample.xlsx");
- var worksheet = workbook.Worksheets.Add("Sample Sheet");
- worksheet.Cell("A1").Value = "Hello World!";
- workbook.Save();
What's New in This Release:
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.
Included formulas:
· All math and trigonometric formulas.
· All text formulas except BAHTTEXT, JIS, and PHONETIC.
· All logical formulas.
· Many statistical formulas.