Build 3.0.0.38 of xlsgen adds geomaps.

Geomaps are, as the name suggests, a mechanism for calculating and rendering maps with visual cues for business intelligence scenarios. The component relies on Google charts of type map. Here are two examples of this.


US states color-coded geomap in xlsgen


Europe countries color-coded in xlsgen

How this can be obtained with source code is actually very easy. Here is how to obtain the geomap for Europe countries :

xlsgen::IXlsWorkbookPtr wbk = engine->New( L"geomaps.xls" );

xlsgen::IXlsWorksheetPtr wksht = wbk->AddWorksheet(L"sheet");

xlsgen::IXlsVisualComponentPtr comp = wksht->NewVisualComponent(L"Geomaps.ARsTdesign.1",
6, // row1
3, // col1
24, // row2
7, // col2
0,0,0,0);

// strings or ISO3166 codes
comp->ParameterByName[L"SetRegions"]->Formula = L"={\"Greece\";\"Germany\";\"France\"}";

// RGB values encoded as strings
comp->ParameterByName[L"SetColors"]->Formula = L"={\"FF4444\";\"44FF44\";\"4444FF\"}";

// optional. strings
comp->ParameterByName[L"SetLabels"]->Formula = L"={\"50 (Greece)\";\"150 (Germany)\";\"100 (France)\"}";

// optional. strings
comp->ParameterByName[L"SetLegends"]->Formula = L"={\"Greece\";\"Germany\";\"France\"}";


For more information, you can take a look at the correponding page in the documentation.