Getting Group Info

Posted by: petri.rasanen on 27 January 2021, 12:00 am EST

  • Posted 27 January 2021, 12:00 am EST


    How can I get row/column grouping info from opened Excel file ? And is the grouping collapsed or expanded? In Spread for WinForms there was method "GetRangeGroupInfo" for this.

  • Replied 27 January 2021, 5:25 pm EST

    Hi Petri,

    You can use the ShowDetail property of the IRange class to get the collapsed/expanded state for the specified range.
    Please refer to the attached sample implementing the same.

    Prabhat Sharma.
  • Replied 27 January 2021, 10:36 pm EST


    Yes I know how to collapse/expand grouping if I know where the grouping exists. But how will I know where the groupings are from opened Excel? Is there some kind of "find groupings" ?
  • Replied 28 January 2021, 7:18 pm EST


    We are discussing this with the developers and will get back to you once we get any update on this from their end.
    [Internal Tracking Id: 3673]

    Prabhat Sharma.
  • Replied 29 January 2021, 1:28 am EST


    I have created a new enhancement request for GcExcel to add support for getting the row and column range groups. We will schedule this enhancement for the 4.2 release.

    Sean Lawyer
    GrapeCity Documents Team
Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels