Dear all,
I have the ultragrid with several bands so that I want to expand all when I export it into excel using UltraGridExcelExporter. How to do it in the coding when before below command run?? set any properties??
ultraGridExcelExporter.Export(reportList, ws, i + 1, 0);
private void ultraGridExcelExporter1_ExportEnding(object sender, Infragistics.Win.UltraWinGrid.ExcelExport.ExportEndingEventArgs e) { foreach (WorksheetRow row in e.CurrentWorksheet.Rows) { row.Hidden = false; } }
I am getting error in foreach loop while using your code to expand all rows.
I am using UltraGridExcelExporter control of Infragistics 2006 Vol 2.