Grouping and Ungrouping Rows and Columns
In a Microsoft Excel file, you can create an outline for the data to let you show and hide levels of detail with a single mouse click.
Click the Outline Symbols, 1,2,3, + and - to quickly display only the rows or columns that provide summaries or headings for sections in a worksheet, or you can use the symbols to see details under an individual summary or heading as shown below in the figure:
|Grouping Rows and Columns.|
Group Management of Rows and Columns
Aspose.Cells provides a class, Workbook that represents a Microsoft Excel file. The Workbook class contains a WorksheetCollection that allows access to each worksheet in the Excel file. A worksheet is represented by the Worksheet class. The Worksheet class provides a Cells collection that represents all cells in the worksheet.
The Cells collection provides several methods to manage rows or columns in a worksheet, few of these are discussed below in more detail.
Grouping Rows and Columns
- First row/column index, the first row or column in the group.
- Last row/column index, the last row or column in the group.
- Is hidden, a Boolean parameter that specifies whether to hide rows/columns after grouping or not.
Microsoft Excel allows you to configure group settings for displaying:
- Summary rows below detail.
- Summary columns to the right of detail.
Summary Rows to Below of Detail
Summary Columns to Right of Detail
Ungrouping Rows and Columns
- First row or column index, the first row/column to be ungrouped.
- Last row or column index, the last row/column to be ungrouped.
UngroupRows has an overload that takes a Boolean third parameter. Setting it to true removes all grouped information. Otherwise, only the outer group information is removed.