Video kann leider nicht angezeigt werden.
Start
Using Excel, VBA and Charts
1. Excel interface
We start Excel via a JavaScript call and copy a GuiXT table variable
2. Record a macro
We record an Excel VBA macro for chart generation
3. Call the Excel macro
We call an Excel VBA macro from a GuiXT script
4. Display the chart
In the VBA macro we export the chart as .png file and display it
5. Add a message
During the chart generation we display a small message window
6. Add drilldown
We show the customer distribution within a country
Sample scripts
Click here to download all project files as .zip archive