How do I skip a column in a grid that I am exporting? I have a calculated column with links in it that I don't want being exporting. All other visible columns should be exported. I tried writing a CellExporting event that cancels the cell but I end up with an empty row. I want to completely skip the first column.
Any help would be appreciated.
Thanks
add the event of begin export which will give you the export layout to control without affecting the layout of the grid.
void UltraWebGridExcelExporter1_BeginExport(object sender, Infragistics.WebUI.UltraWebGrid.ExcelExport.BeginExportEventArgs e)
{
e.Layout.Bands[0].Columns[0].Hidden = true;
}
hope this helps
I'm using ig 10.3 WebExcelExporter. I can't find this event?
That got me going in the right direction. Maybe there is another way but I used this event in 10.3
this.eExporter.Exporting += new ExcelExportingEventHandler(eExporter_Exporting);
void eExporter_Exporting(object sender, ExcelExportingEventArgs e){ e.Worksheet.Columns[0].Hidden = true;}
Thanks for your help!