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
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!
I'm using ig 10.3 WebExcelExporter. I can't find this event?
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