Hi, Grid has a single fixed header on the top using HeaderPlacement .FixedOnTop; for all the GroupBy Rows. When i am trying to export this Grid to excel, I see individual headers under each GroupBy Row. Please advice how my excel report can have a single header on top instead of multiple headers. Thanks
What version of the grid are you using?
The HeaderPlacement property was not honored by the UltraGridExcelExporter component until very recently. So you may need to get the latest service release.
How to get the latest service release - Infragistics Community
Hi Mike,
We are using v9.2
Yes, i want to expand everything by default and do not want to show the expansion indicators in the Excel file.
And i am able to achieve the same, by using below line :
this.UlatrgridGridExcelExporter1.OutliningStyle = OutliningStyle.None;
Thank you for your responses.
Hi,
I'm afraid I do not understand what you are asking. The GroupByRowExpansionStyle property only affects the grid on the screen. Are you saying you do not want the expansion indicators to show up in the resulting Excel document at all? Or that you want everything to be expanded by default in the Excel file?
Thanks Mike.Will try this.
Also how can i disable the groupExpansionIndicators(GroupByRowExpansionStyle) in excel.
Okay... as I said, the UltraGridExcelExporter did not honor the HeaderPlacement property. The main reason for this is that the HeaderPlacement property was added to the grid after the UltraGridExcelExporter was written, so it was something of an oversight that the exporter was never updated to honor the new property.
As I also said, this was recently fixed, but I'm pretty sure the fix was only made in the more recent versions of the controls - and I am pretty sure it's not fixed in v9.2.
If you want to be sure, you could try downloading the latest service release and see if it works.
But if that does not work, then there are two potential solutions for you:
1) Upgrade to the newest version of NetAdvantage.
2) Handle the events on the UltraGridExcelExporter and watch for the HeaderExporting event and cancel the event for the headers you don't want. You will have to find some way to track which headers they are. But it seems like this should be pretty easy, you just let the first set of headers be exported and then cancel all the rest.