How to export the data from my Mendix app to excel?

0
I want to export the data from my Mendix app to excel. Is there a method to set this up online in my browser? Or do I need to use the Mendix Desktop Modeler to set up export to excel? Thanks.
asked
5 answers
5

Hi 

You can use the excel exporter module from the appstore. You can find more information here: https://docs.mendix.com/howto/integration/using-the-excel-exporter

If you want to export data from a grid you can go without the export module and simply add the button export to excel (or export to csv) to your grid.

Kind regards,

Jeroen

answered
1

There is an app called Excel exporter in the App Store. With that app you can create excel exort files.

answered
0

Thanks Jeroen. I want to export data from a grid. Is there an info page for this? I'm not seeing the export for excel button in the webmodeller or the desktop modeller. What kind of grid do I need to create to do this? I haven't been able to find the documentation or tutorial that describes how to do this. 

answered
0

Create a button export to CSV. This can be read by Excel. See the documentation here: https://docs.mendix.com/refguide/export-to-csv-button

Regards,

Ronald

 

answered
0

Thanks for everyone's help, got it working now. The data source for the grid has to be set to Xpath. Then you can add the "Export to Excel" button via right click, in the control panel of the grid. This option is very quick to set up and does the job in my case, so I didn't need to install the Excel exporter app. It had to be done in the Desktop Modeler, there is not yet any option to set up export to excel, in the web modeller, that I could see. 

 

answered