Documents for Excel, Java Edition Documentation
Features / Group
In This Topic
    Group
    In This Topic

    When you have extensive amount of data in spreadsheets, it becomes difficult to process relevant information for business management, analytics and data visualization.

    GcExcel Java allows you to summarize bulk data in groups so that complex spreadsheets are easier to read, navigate, and manipulate. Each group in GcExcel Java is distinguished with a group header row next to it which can be used to display or hide information as and when required. In order to expand a group to display rows and columns that have been hidden, you can set the setShowDetail method of the IRange Interface to boolean true and in order to collapse the expanded rows or columns,you can set the setShowDetail method of the IRange Interface to boolean false.

    Applying grouping in a spreadsheet involves the following tasks:

    Note : When grouping is applied, rows of data are automatically sorted in ascending order against the grouped columns.