Excel Export

0
Hello,I am currently using DataGrid 2 to display data. I want to export this data, and I have used the "Export to Excel" function to download it. However, the issue is that only the visible data (the columns currently shown in the grid) gets exported. There are more columns available that are not displayed. What I need is to export all data, including the hidden columns, and ensure the export is sorted according to the user's sorting in the DataGrid. For example, even if the DataGrid displays only 5 columns, the exported Excel file should include all relevant data associated with the sorted rows.
asked
2 answers
0

Hi there,

The Data Grid 2 export to Excel action relies on the current state of the Data Grid. Therefore, only filtered rows and visible columns will be exported.

 

To have greater control on how your export works, you'll likely need to use other marketplace modules. Here are some modules that you could use to export all columns:

For Excel exports

Excel Exporter: https://marketplace.mendix.com/link/component/726

 

For CSV exports

CSV: https://marketplace.mendix.com/link/component/108605?ste_sid=54311c51745f0687d9ef62a972b98859

 

 

I hope this helps,

Liam

answered
0

Hi Pankaj,

Export to Excel only export the visible column data but if you want to export all hidden columns data also then you have to use advanced excel module or template excel module.

Try below article

 

https://medium.com/@mohammad.saqib_1262/part-2-how-to-export-data-to-excel-with-custom-filters-b3aadae32207

answered