Skip to main content

Hi All,

 

As you might be already aware we are working towards an epic about enhancing the Tabular Data Manipulation experience on WebUI. We are proud to announce that, as part of its incremental development, we have released Excel Upload/Download support for the current Table widget in the recent 4.86.1 version release.

 

This Excel Upload/Download support feature of the Table widget is available as an Experimental Feature from AIMMS 4.86 onwards. You can switch on the feature by checking the ‘Excel Upload/Download Support’ box in the Experimental Features dialog.

 

With this new feature we now provide the ability to download the WebUI Table Data onto an Excel file. And the ability to upload data from an Excel file to a WebUI Table.

This feature unveils the possibility that one could now download the Table data onto an Excel file, make the required changes to the data in the Excel file and save it. One can utilize Excel features like Block selection and editing, sorting/filter, and usage of formulas to modify the data. And upload the file onto the Table so that the data reflects back on the WebUI and the model.

 

With the current Excel Upload/Download support, there are some limitations on what you can and cannot do. For details on those and on the feature itself, please see the documentation. 

 

Curious to know if you got a chance to try out this new feature.   

  • Are you happy to use this feature in its current state? If not, why?
  • Do you see something you would like us to improve?

 

Please leave your feedback and suggestions in the comments.

 

Thanks,

WebUI Team

Is it possible to translate the identifiers in the excel file? It would be nice to take advantage of the already existing translations in the .properties file, which are currently being applied in the WebUI.

Right now, when I export a excel file I always see the original identifier name:

 

 

Hi @jean.patrick,

Currently, the Excel Upload/Download support feature of the Table widget does not take into account translations that could have been applied using .properties file.

We are aware of it, and conscoiously did not support this feature.

It is on our backlog. And we would like to support it in future.

 

Curious to hear more feedback from you on this Excel Upload/Download support feature. Would you mind sharing it.

 

Thanks,

Madhu Krishnappa

Hi @jean.patrick,   

 

With the most recent AIMMS 4.89.1 release, two new predeclared identifiers, webui::IdentifierElementText and webui::IdentifierTooltip ranging over the predeclared set AllIdentifiers, have been added to the WebUI library.

 

This webui::IdentifierElementText predeclared string parameter can be used to specify meaningful display text for Identifiers in your WebUI and is displayed as such on the downloaded or uploaded Excel file. Please read here for further details about this.

 

Similarly, this webui::IdentifierTooltip predeclared string parameter can be used to specify the tooltip which will be displayed when hovering any identifier name which is displayed in the WebUI.

 

Do let me know if this information helped you.

 

Thanks,

Madhu Krishnappa

Terms & Conditions

Didn't find what you were looking for? Try searching on our documentation pages:

AIMMS Developer & PRO | AIMMS How-To | AIMMS SC Navigator