Data Grid 2 with Export as Excel

2
Let me know if any option to export as excel in data grid2 
asked
9 answers
5

Hi Ganga,

Great news! In the latest Data grid 2.0 they've added a new action "- A new "Export_To_Excel" JS action".

https://marketplace.mendix.com/link/component/116540

 

With this you can create your own export to Excel button! 

 

Kr,

Martijn

answered
3

Hi,

 

Datagrid2 currently does not have OOTB excel export. Please refer here for the alternative: 
https://forum.mendix.com/link/space/microflows/questions/123258
Essentially, for now you need to use the excel exporter module.

answered
2

@Leon, I just do this in the nanoflow which works for me. Do you get Javascript errors in the console?

Screenshot 2023-11-07 at 17.09.39.png

answered
0

Hii

go throug the excel exort mendix document ,below link

https://docs.mendix.com/howto/integration/using-the-excel-exporter/

answered
0

Hi, 

You cannot be used like datagrid export to excel as by rightclick and add button in datagrid2. Download XLS report from marketplace and do it

answered
0

I added an an idea about it as well. Give it some love, then it might get implemented faster ;-)

https://forum.mendix.com/link/space/widgets/ideas/4071

answered
0

hi all did this work ?can someone show the Nanoflow configuration to make this work 

answered
0

Hi ,

Just follow the snapshot and you'll achieve the flow. If you have any queries just let me know. Happy to help...

 

Screenshot 2024-02-07 152733.png

answered
-1

Hlw,

     you can follow these steps:

  1. In the Mendix Modeler, open the page containing the data grid that you want to export.

  2. Select the data grid on the page.

  3. In the Properties pane click on the "Export to Excel" button under the "General" section.

  4. In the "Export to Excel" dialog box, you can choose to export all data 

  5. You can also give the exported file a name.

  6. Click on the "Export" button to generate the Excel file

The exported file will contain the data from the data grid, including any formatting and column headers.

answered