When a grid is grouped by some column and exported to excel using UltraGridExcelExporter, how to show headers only once and also how to exclude empty rows?
Thanks,Rajesh.
Hi Rajesh,
rajesh_m said:how to show headers only once
I'm not sure there's any way to do this. The exporter currently does not honor the HeaderPlacement property in the grid. This is a feature we may add in the future, but right now, I'm not sure it's possible. Maybe you could achieve this by handling events of the UltraGridExcelExporting and cancelling some of the headers, but how it would be pretty tricky.
rajesh_m said:also how to exclude empty rows?
I'm not sure what this means. What empty rows are you referring to?
I am using the below property for the summary display area
gridToFormat.Grid.DisplayLayout.Override.SummaryDisplayArea = SummaryDisplayAreas.TopFixed
Or SummaryDisplayAreas.GroupByRowsFooter Or SummaryDisplayAreas.InGroupByRows
So, when I export the grid to excel which is grouped by some x column, I see an empty row after each header.
Thanks,Rajesh