Excel 2007 Support

Essential XlsIO has basic support for working with Excel 2007's xlsx format. You can work with all basic operations and same APIs of Biff8 formats.

Essential XlsIO provides support for working with Excel 2007's xlsx format. You can perform operations like cell merging, get/set data, basic styles and range operations like copy cells, insert row/column, clear cells, etc., You can also preserve objects like autofilter and VBA macros, when xlsx file is resaved with Essential XlsIO. You can also open the xlsx files and resave it as Excel 2003 file format. It is also possible to fill more than 65000 rows.

XlsIO gives your worksheet a better presentation with gradient cells. Rich styles in Excel 2007 format with few new APIs can be applied. You can apply gradient styles and indexed colors to cells and provide rich look with various gradient styles and variants of Excel 2007.

It also supports the inclusion of multiple constraints(more than 3) in conditional formatting, which is a new feature in Excel 2007 format.