XEROF

xlsgen 4.5 preview #5 : Traffic lights and gauges

Traffic lights and gauges need not much explanation. They can be programmatically set to reflect levels or states that are part of business decision making.

Contrary to other visual components in xlsgen (vu-meter, sparklines, google charts, geomaps, ...), whole arrays of traffic lights or gauges can be created in the same bounding area, not just one.

Name	Type	Description
SetGreenThreshold	integer or double	value below which traffic light signals green. Default value is 0.
SetOrangeThreshold	integer or double	value around which traffic light signals orange. Default value is 50.
SetRedThreshold	integer or double	value above which traffic light signals red. Default value is 100.
SetVertical	boolean	force the orientation of the traffic light(s)
SetValue	integer or double (or range of integers or doubles)	value itself or range of values.
SetTitle	string (or range of strings)	title or range of titles.
ResetValues	None	deletes current value(s).

Here is how to create traffic lights :

C/C++ code



xlsgen::IXlsEnginePtr engine( __uuidof(xlsgen::CoXlsEngine) );

xlsgen::IXlsWorkbookPtr wbk = engine->New( L"trafficlights.xlsx" );

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

xlsgen::IXlsVisualComponentPtr comp = wksht->NewVisualComponent(L"TrafficLight.ARsTdesign.1",
       2,5, // row1, col1
       6,8, // row2, col2
       0,0,0,0);

// three traffic lights
comp->ParameterByName[L"SetValue"]->Formula = L"={80;50;70}";
comp->ParameterByName[L"SetTitle"]->Formula = L"={\"my title (80)\";\"2nd title\";\"3rd title\"}";

wbk->Close();