I'm using the Infragistics.Excel namespace in order to create an excel workbook with the information I have on a Ultragrid grid. I can't use the Exporter you have because of some special look & feel the users need on the exported sheets.
My problem is that I still can't find how to group rows or columns. This is done in VBA by using something like
SELECTION.Group.
I'm sure this is something that I should be able to do, because the exporter get rows and cols grouped, but I still don't know how to group rows programatically.
Any help would be appreciate
The WorksheetRow and WorksheetColumn classes have an OutlineLevel property. Rows and columns with the same outline level will be grouped in the exported workbook.