Essential XlsIO allows advanced conditional formatting on spreadsheet cells in Excel 2007 XLSX format.

It has well-defined APIs to read and write the conditional format from or to a cell in a workbook. It also allows the setting of various Excel 2007 visualizations such as icon sets, color scales, and data bars based on conditions. The following image illustrates various visualizations applied using Essential XlsIO based on conditions.

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

The following image illustrates this feature in MS Excel 2007.

Excel 2007 and Excel 2010 Support

Essential XlsIO is one of the first products to natively support the XLSX file format. Supported features include creating spreadsheets in Excel 2007 and Excel 2010; the advanced features of Excel 2007 and Excel 2010 are also supported, such as conditional formatting representations, pivot tables, and rich 2007 built-in styles.

• XLSX Support
• Cell Styles Support
• Advanced Conditional Formatting
• Tables Support
• Pivot Table