I'm using Infragistics.Excel to manually create my excel spreadsheet, and I'm using the OutlineLevel property on the worksheet rows. I can get it to display in the output file correctly, but by default, the groups are expanded. How can I get them to be collapsed before I save them to a file?
Hide all of the rows that belong to the group you want to collapse. This can be done by setting the Hidden property of the WorksheetRow objects representing your rows.
Excel "collapses" groups by hiding the corresponding rows, and "expands" them by unhiding them.
Thanks for the clarification. I completely mis-interpreted how to use the Hidden property. When I first tried it, I set Hidden = true on the row with the "+/-" expansion indicator (thus hiding the row itself), rather than setting Hidden = true on all of its "child" rows. Your answer worked for me. Thanks!