Question

Export to excel in datagrid 2

4

Hi Team, We have ‘Export to excel’ button available in datagrid. Please let me know whether similar option is available in datagrid 2? My requirement is to export the data into excel based on the column selection by the user in the datagrid 2. Regards, Megha

asked 2021-09-02

Megha George

6 answers

Marick Hoeijenbos · Answer 1 · 2023-11-01

Yesterday (31 October 2023) there has been an update on the Datawidget module with a new "Export_To_Excel" JS action.

Datawidget Marketplace Mendix

Lukas Tost · Answer 2 · 2021-09-02

Hi Megha George,

This feature does not seem to be included. You might have to fall back to the excel export module, but achieving the same functionality will be an effort – the export to excel functionality that is integrated to the standard data grid exports exactly what you see – if you filtered your list, the exported data is also filtered accordingly. You might have to use a custom filtering which passes the result list to the excel export..

Vsevolod Kosminskyi · Answer 3 · 2022-02-14

I think you can use ‘Saved attribute’ setting in a filter to store the last value. Then create a custom export logic to generate excel file based on stored values

Juan le Roex · Answer 4 · 2022-07-07

This widget needs a lot of development to handle selection processes.

Ragul raj · Answer 5 · 2022-07-08

Hi Megha,

There is no Export to Excel option in datagrid 2 so you need to make an customized export excel option like this for the respective data grid Source.

Dileep Midasala · Answer 6 · 2023-10-26

That's only button right? we need how you implemented .