Hi, in the following example I have a sample grid which has two columns. The first column is grouped, and the second column is summarized (using SUM and summary.DisplayFormat = "{0}" so that it won't show the 'Sum =' text):
When I export to excel, I get the following result in the excel file:
My question is: is there a way to NOT export the detail rows/outline tree and only show the top group summary row? I've used the following: Cancel on the RowExporting event, and it does remove the detail rows:
private void mygrid_RowExporting(object sender, Infragistics.Win.UltraWinGrid.ExcelExport.RowExportingEventArgs e){ if (e.CurrentOutlineLevel.Equals(0)) e.Cancel = false; else e.Cancel = true;}
but I am unable to figure out how to remove the rows highlighted in red. The layout of the export that I am trying to obtain is:
Hi,
It looks like you are cancelling the child rows, but no the headers. So you could handle the HeaderRowExporting event and do the same thing you are doing in the RowExporting. But this won't realyl work well, because you will still get the outlining.
If you know you are only going to have one level of grouping, then here's a better solution:
private void ultraGridExcelExporter1_InitializeRow(object sender, Infragistics.Win.UltraWinGrid.ExcelExport.ExcelExportInitializeRowEventArgs e) { if (e.Row.IsGroupByRow) e.SkipDescendants = true; }
Hi Mike,
I am also having the same requirement as him and this works great. Except that the column headers are not included in the exported xls. How can I put the column headers along with the data for this type of scenario?
Thanks,
Andro