Enhanced Excel 2007 XML-based file format support Version 6.1 brings all basic support for xlsx format of Excel 2007. You can work with most of the objects in Excel that are supported with Biff8 format. This includes objects such as autofilter, page set up options, hyperlinks, comments, data validations, worksheet properties, etc… This version allows to word with indexed colors which are closer to 32bit colors of Excel 2007. You can create more than 3 rules with Conditional formatting and format the Excel sheet with indexed colors with of Excel 2007 format.

Cell Styles support Spice up Give your worksheet a better presentation with gradients cells. Rich styles in Excel 2007 format with few new APIs can now be applied with this new version. You can apply gradient to cells and provide rich look with various gradient styles and variants of Excel 2007.

Workbook Protection support This version brings up the support for protecting the workbook with password. This feature allows you to secure your workbook from changes. Unauthorized user cannot modify your workbook structure and window and hence provides file level security for your document. Secure your documents with Essential XlsIO rich security features.

Copy Conditional formatting Rich formatting based on conditions can be copied from one range of cells to another range. This version allows copying the formatting in the cell to another while inserting, copying and moving the cells. Hence you don’t have to worry about applying conditional formatting again after the copying cells.

Styles Include support Customize the styles settings to apply to your worksheet. Version 6.1 brings the support for including or excluding styles in a worksheet. If you do not want to include a format to be applied and want to change the default setting, you use Essential XlsIO APIs for changing the settings similar to that of Microsoft Excel.