A vumeter can be customized like changing colors in order to put an emphasis, adding a title, and so on. sparklines (to help working with business intelligence indicators).Ī vumeter is an ActiveX control whose purpose is to provide a clue of where a target value is inside boundaries.The xlsgen install has a sample code called visual component written in no less than 7 programming languages, showing the basics of visual components.Īlso, xlsgen installs four such controls : discovery mechanism which allows to find and help programming ActiveX controls parameters.automatic snapshot creation which allows to insert a regular picture in any Excel spreadsheet.
Thus you can bind values in cells to compute values contributing to what defines the behavior and layout of any ActiveX control. ability to parametrize those controls using Excel formulas.ability to instantiate any ActiveX control, for instance the Microsoft chart control, the Windows media player, business intelligence indicators such as vumeters, traffic lights, sparklines and so on.Visual components are a very powerful feature of xlsgen that goes beyond Excel capabilities : Xlsgen has an open architecture which allows general-purpose ActiveX controls to be instantiated, parametrized using Excel formulas, and create snapshot pictures in Excel.
0 kommentar(er)
