How to import Excel Data into Datagrid2 and export the data from Datagrid2 into Excel

0
Dear Mendix Experts,   We wanted your guidance and suggestion on our query - How to import Excel data into Datagrid2 and export the same data from Datagrid2 to Excel.    Thanks & Regards, Team IMTS
asked
2 answers
0

hi, 

 

First of all, you need to create templates in the Import and Export data modules in the marketplace. You need to create a custom data filter to export the filtered data in Datagrid2. You should apply a similar filter to the one you created in the microfloow that you will export to Excel.

You can watch this video for the custom filter. It is in Turkish but you will still understand.

https://www.youtube.com/watch?v=HILFei971Hg

answered
0

I would recommend using the data importer module for importing data from Excel files and relying on the Export to Excel nanoflow actions to directly export data from the datagrid2 table shown to the user (incl. applied filters).

answered