Build 3.5.0.15 of xlsgen adds rendering support for icon sets in print, print preview, PDF.

Icon sets are a special type of conditional formatting introduced in Excel 2007 and updated in Excel 2010 by adding more icon sets and making it possible to set custom icon sets (including a no icon case).

Icon sets are conditional formattings rendered in cells on the left, that are meant to alert visually someone who sees the data in cells. Clearly, icon sets belong to business intelligence.

17 icon sets were introduced in Excel 2007. These have either 3 icons in each, 4 icons or 5 icons. Each icon reflects a state, such as a traffic light color.

Excel 2010 added 4 icon sets to it, making it a total of 21 icon sets to choose from.

xlsgen takes care of all the conditional formatting formula rule evaluation and icon rendering.

Better yet, in the new PDF, icon sets are rendered as vector shapes, which means they scale properly, contrary to Excel itself which renders icon sets as low resolution bitmaps.

Below is an example of icon sets.


Rendering all icon sets in xlsgen next to cells