How to collapse Excel’s grouped rows programmatically in VB.NET? RRS feed

  • Question

  • I made an app that creates an Excel report about sales to every customer quarterly. It looks like this: for every customer I have four rows for each quarter of the year, and under those four rows there’s fifth one with total for the year. First four rows are grouped, and that’s first level of grouping.

    At the very bottom, I have another row that holds total for all customers together. So I grouped all rows from second row to penultimate one, and that’s second level of grouping.

    At this moment, when my app finishes, everything is un-collapsed. What I want is this: when sales manager starts my app and creates report, I want that everything is collapsed so they could un-collapse only those particular details that are of interest.

    I managed to group rows, but I don’t know how to collapse them. If anyone has any info about this, please help.

    Thanks in advance.

    Saturday, April 7, 2018 1:49 AM


All replies