Many of our projects include export functionality to Excel; which is a good way to allow the end-user to continue to work on the data and/or use it as a report out. Proper formatting of the excel file is in these cases high on the priority list of the users. One can think of: setting fonts, right number of decimals, putting data in a pivot (correctly organized). Basically, saving the user the manual work to redo these formatting actions after each export to excel.
In the win-ui we applied the following trick to get the excel file formatted as desired:
- Create an excel macro to perform all the required actions
- Include an excel file with the macro in the aimms project
- When exporting, use a copy of that excel file, put the data in and run the macro via the aimms function
Since we are developing web-ui apps, which are cloud deployed, this trick is not available any more. The model runs in the cloud without the ability to running an excel macro. Because the AIMMS Excel Library (axll) does not contain a function like
What are the possibilities to control the formatting in excel files created from a webui app?
Best answer by mohansxView original