Code breaking changes:

SetHeaderFooterMargin method in PrintOptions has been removed. Use HeaderMargin and FooterMargin properties instead.

Changes:

• Added support for tab and comma delimited export.

• Fixed error with Workbook's Add(string sheetName) method, which added 2 sheets instead of one.

• Fixed error in Worksheet's ImportTable method where column Index was using 1 based index.

• Fixed error where merged cells spaned across multiple lines caused a Table error in Excel.

• Fixed error where DateTime values were saved in 12 hour format, but did not took AM/PM into account and always saved as AM.

• Converted HeaderMargin and FooterMargin fields to properties and removed SetHeaderFooterMargin method.

• Added Header and Footer string properties

• Added Multipart header & footer string helpers i.e. SetHeader and SetFooter.

• Added support for print gridlines (EnableGridlines property).

• Reset many internal values to private & cleaned up project.

• Added Currency display format.

• Fixed error where GetValue was not retrieving decimal value.

• Set the default display format of dates to GeneralDate.

For a full brief list of features, look here. For a detailed feature set, download the documentation from the page mentioned.

Downloads

• Full Documentation 3.06 (282 KB)
• Library DLLs v3.29 for .Net 2.0/3.0/3.5 (43.2 KB)
• ExcelXml Library Source v3.06 (985 KB)
• Extensions Library Source v3.06 (103 KB)

Code breaking changes:

Formula system does not work the way it used to, so the previous code might break. For backward compatibility, I have included a static class FormulaHelper which can be used with the previous code. Just replace the previous code in the following way:

   1:  cell.Value = new Formula("Sum", new Range(sheet[3, 3], sheet[6, 3]));

to

   1:  cell.Value = FormulaHelper.Formula("Sum", 

   2:       new Range(sheet[3, 3], sheet[6, 3]));

Changes:

• New Formula system implemented.

• RowSpan and ColumnSpan properties added to cell.

• Small error in named range rename fixed.

• Freeze column won't work if freeze row is set. Fixed.

• Style was not saved in Column export. Fixed.

• Assembly file contained wrong information about this library. Fixed.

• Workbook export can throw a NullReferenceException when new XmlWriter is created. Fixed.

• Documented IStyle interfaces.

For a full brief list of features, look here. For a detailed feature set, download the documentation from the page mentioned.

Downloads

• Full Documentation 3.06 (282 KB)
• Library DLLs v3.06 for .Net 2.0 (43.2 KB)
• Library DLLs v3.06 for .Net 3.5 (42.8 KB)
• ExcelXml Library Source v3.06 (985 KB)
• Extensions Library Source v3.06 (103 KB)

The source code for the library is now open. You can download the source code and modify or use it in any way.

Download from here: ExcelXml library source code v2.89 (966 KB)

If you make any major amendments, do let me know so that I can incorporate those changes into the library.

Enjoy!

Yogesh