Build 3.5.0.90 of xlsgen adds 40 Office themes to the object model for rendering charts.
So far xlsgen had 4 themes (classic, modern, olive and marine). This build introduces all 20 Office themes that are part of Excel 2007, in addition to all 20 Office themes that are part of Excel 2010.
In Excel, themes can be changed by clicking on the Page layout ribbon then on the Theme drop down. Picking one immediately affects all charts and tables.
In xlsgen, theme can be set by using the ThemeManager object at the workbook level.
The 40 Office themes from Excel 2007 and Excel 2010 are :
[helpstring("Workbook Theme, office (Excel 2007)")] workbooktheme_office = 4,
[helpstring("Workbook Theme, adjacency")] workbooktheme_adjacency = 5,
[helpstring("Workbook Theme, angles")] workbooktheme_angles = 6,
[helpstring("Workbook Theme, apex")] workbooktheme_apex = 7,
[helpstring("Workbook Theme, apothecary")] workbooktheme_apothecary = 8,
[helpstring("Workbook Theme, aspect")] workbooktheme_aspect = 9,
[helpstring("Workbook Theme, austin")] workbooktheme_austin = 10,
[helpstring("Workbook Theme, black tie")] workbooktheme_blacktie = 11,
[helpstring("Workbook Theme, civic")] workbooktheme_civic = 12,
[helpstring("Workbook Theme, clarity")] workbooktheme_clarity = 13,
[helpstring("Workbook Theme, composite")] workbooktheme_composite = 14,
[helpstring("Workbook Theme, concourse")] workbooktheme_concourse = 15,
[helpstring("Workbook Theme, couture")] workbooktheme_coutoure = 16,
[helpstring("Workbook Theme, elemental")] workbooktheme_elemental = 17,
[helpstring("Workbook Theme, equity")] workbooktheme_equity = 18,
[helpstring("Workbook Theme, essential")] workbooktheme_essential = 19,
[helpstring("Workbook Theme, executive")] workbooktheme_executive = 20,
[helpstring("Workbook Theme, flow")] workbooktheme_flow = 21,
[helpstring("Workbook Theme, foundry")] workbooktheme_foundry = 22,
[helpstring("Workbook Theme, grid")] workbooktheme_grid = 23,
[helpstring("Workbook Theme, hardcover")] workbooktheme_hardcover = 24,
[helpstring("Workbook Theme, horizon")] workbooktheme_horizon = 25,
[helpstring("Workbook Theme, median")] workbooktheme_median = 26,
[helpstring("Workbook Theme, metro")] workbooktheme_metro = 27,
[helpstring("Workbook Theme, module")] workbooktheme_module = 28,
[helpstring("Workbook Theme, newsprint")] workbooktheme_newsprint = 29,
[helpstring("Workbook Theme, opulent")] workbooktheme_opulent = 30,
[helpstring("Workbook Theme, oriel")] workbooktheme_oriel = 31,
[helpstring("Workbook Theme, origin")] workbooktheme_origin = 32,
[helpstring("Workbook Theme, paper")] workbooktheme_paper = 33,
[helpstring("Workbook Theme, perspective")] workbooktheme_perspective = 34,
[helpstring("Workbook Theme, pushpin")] workbooktheme_pushpin = 35,
[helpstring("Workbook Theme, slipstream")] workbooktheme_slipstream = 36,
[helpstring("Workbook Theme, solstice")] workbooktheme_solstice = 37,
[helpstring("Workbook Theme, technic")] workbooktheme_technic = 38,
[helpstring("Workbook Theme, thatch")] workbooktheme_thatch = 39,
[helpstring("Workbook Theme, trek")] workbooktheme_trek = 40,
[helpstring("Workbook Theme, urban")] workbooktheme_urban = 41,
[helpstring("Workbook Theme, verve")] workbooktheme_verve = 42,
[helpstring("Workbook Theme, waveform")] workbooktheme_waveform = 43
As a consequence of a number of those themes bringing along with them picture parts used for textures, xlsgen.dll is now 400 KB bigger in size. Both the 32-bit and the 64-bit versions.