DataWidget: Export to Excel --> Export also hidden columns
0
Dear community, I have a DataGrid2, which receives a list of data via a microflow. This list of data is the result of an SQL query, which returns the corresponding list and is displayed in the DataGrid2. Now I would like to give the user the possibility to export the list to Excel. While searching for corresponding features, I found the “Export to Excel” feature. This works quite well and exports everything that can be seen on the DataGrid2 to Excel. However, I noticed that it exports 1:1 exactly what is visible in the DataGrid2. For entities with a large number of columns, the DataGrid2 becomes very confusing. If the user hides some columns and then exports them, the hidden columns are not exported. That's what bothers me about this feature. Is there a way to pass the list on which the DataGrid2 is based to the Export to Excel? This would make the export independent of what the user shows or hides, as all columns are exported with the export. Has anyone ever had a similar problem and can give me a tip? thanks
asked
Hamid Rezaie
2 answers
0
Hi Hamid,
I think you are using Export To Excel Action directly in microflow/nanoflow .
Try to use Advance Export To Excel or Export to Excel by template.