Skip to main content
Solved

How to edit multiple cells of a WebUI table?


Forum|alt.badge.img
Dear Community,

we want to be able to edit multiple cells of a WebUI table, like using shift or ctrl to celect the cells and later edit them at once. We would like to be able to use copy paste as well. We coundn't find any resources describing a way of enabling these functions. If you know how to do it, or have some helpful resources please share it with us.

Best answer by mateusarakawa

Hi, @zoltanlelkesjr .

We are using excel for mutiple edit. So, for each table/context we have an aimms axll library procedure to import/export to/from xlsx.

WebUI Upload and Download widgets allow you to access the excel file within the server.
https://documentation.aimms.com/webui/upload-widget.html
https://documentation.aimms.com/webui/download-widget.html
View original

mohansx
Forum|alt.badge.img+5
  • Former AIMMSian
  • July 16, 2019
Hello @zoltanlelkesjr , the WebUI table does not support multi cell as of now.

Forum|alt.badge.img
Are you planning to add this feature in the near future?

mateusarakawa
AIMMS Champ
Forum|alt.badge.img+2
Hi, @zoltanlelkesjr .

We are using excel for mutiple edit. So, for each table/context we have an aimms axll library procedure to import/export to/from xlsx.

WebUI Upload and Download widgets allow you to access the excel file within the server.
https://documentation.aimms.com/webui/upload-widget.html
https://documentation.aimms.com/webui/download-widget.html

Jess Es
Forum|alt.badge.img+6
  • Grand Master
  • July 25, 2019
Hi @zoltanlelkesjr , just wondering if this thread answered your question, or you found another way? Would you mind to mark the "best answer"? (It helps others understand what to do if they have similar problem.)

Thanks!

Madhu Krishnappa
AIMMSian
Forum|alt.badge.img+5

Hi All,

 

With the 4.86.1 version release we provide Excel Upload/Download support for Table widget.

 

More details about it is shared here 

https://community.aimms.com/product-updates/excel-upload-download-support-for-table-widget-1257

 


Mischa
AIMMSian
Forum|alt.badge.img+6
  • AIMMSian
  • July 11, 2022

Hi,

 

With the AIMMS 4.87.1 Feature Release that we released today, both block editing and copy/paste are now possible in the Table widget (albeit as an Experimental Feature still). For details, please see the documentation.

 

Regards,

Mischa


Reply