Hello,
How can I export grid data (which is in expand/collapse format) to Flat Row/Column without Expand/ collapse?
Thanks
Venkatesh
Thank you for your quick reply. This is not what i'm looking...
My grid looks somthing like this
Col1 Col2 Col3 Col4
Col1 Col2 Col3
When export to excel i want it to look like this
Hello Venkatesh,
When the export of the grid starts the grid layout gets cloned. During the export this cloned version is used. What you can do, to have grid exported as flat one without groups, is to clear the SortedColumns collection of the cloned layout band. Nice place to do this is in ExportStarted event of UltraGridExcelExporter. You can use code like this:
private void UltraGridExcelExporter1_ExportStarted(object sender, ExportStartedEventArgs e){ e.Layout.Bands[0].SortedColumns.Clear();}
Please check the attached sample project showing this approach and let me know if this is what you are looking for or if I am missing something.