Hi,
I'm using IG 9.2's support for export to Excel. I would like to exclude a couple of columns from being exported to Excel. Can you let me know how that could be done?
Thanks,
Joe
Hello Joe,
The easiest way I found is to register for the EndExport event and simply manipulate the Excel Workbook form there. E.g:
e.Workbook.Worksheets[0].Columns[0].Hidden =
true;
Hope this helps.
Sincerely,
Petar Monov,
DS Engineer,
Infragistics Bulgaria
Thanks Petar but this may not work for me as the column still exists in the Excel. My users need the excel to feed into another system or save as csv where this column would still show.
When handling the InitializeRecord event the InitializeRecordEventArgs has a SkipRecord property. Isnt there something similar for columns ?