Advanced Conditional Formatting
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.
Advanced Conditional FormattingEssential 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 - Conditional FormattingExcel 2007 Support
Essential XlsIO is one of the first products to natively support Excel 2007 XLSX file format. Advanced features of Excel 2007 like Conditional formatting representations,pivot tables, rich 2007 built in styles are also supported.
