Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
25
Grouping Rows/Cols in an exported Excel
posted

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

Parents
No Data
Reply
  • 44743
    posted

    The WorksheetRow and WorksheetColumn classes have an OutlineLevel property. Rows and columns with the same outline level will be grouped in the exported workbook.

Children
No Data