Exporting to Excel Hidden Columns

0
Hi Team,I am exporting to excel from a DataGrid2 by using Nanoflow activity Export to Excel by giving DataGrid name and it is working perfectly fine.But it is always exporting only those columns which are visible on UI.Suppose if I hide any columns using Column selector, the hidden columns are not being exported.Any idea how can we achieve this?We are using 9.24.29 Studio proRegardsAjay
asked
1 answers
0

Hi Ajay

The built-in ExportExcel only exports the grid as per its current UI state. So if columns are hidden using the column selector/personalization, they will not be included in the Excel export.


There is no direct setting in the exportToExcel action to include hidden columns.


you can use the Excel Exporter module where you explicitly define all required columns.


If the export must also respect the same filters as the grid, keep the filter values in a helper object and use the same object both for the DataGrid2 datasource and for the Excel export logic.


I believe that should work.

answered