Using the Infragistics.Excel library, I see that it is possible to create hierarchies in workbooks via setting the outline level. Is it possible to set whether or not each outline level is expanded or collapsed when the user opens the spreadsheet via code?
If you set Hidden all rows/column in the group to True, that will collapse the group. If you set it to False on all rows/columns, it will expand the group.