Hiding and Showing Rows and Columns

Sometimes, it makes sense to hide certain rows or columns in a worksheet and display them later. Microsoft Excel provides this feature, and so does Aspose.Cells.

Controlling the Visibility of Rows and Columns

Aspose.Cells provides a class, Workbook, that represents a Microsoft Excel file. The Workbook class contains a WorksheetCollection that allows developers to access 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 for managing rows or columns in a worksheet. A few of these are discussed below.

Hiding Rows and Columns

Developers can hide a row or column by calling the HideRow and HideColumn methods of the Cells collection, respectively. Each method takes the appropriate row or column index as a parameter to hide the specific row or column.

It is also possible to hide a row or column by setting the row height or column width to 0, respectively.

Showing Rows and Columns

Developers can show any hidden row or column by calling the UnhideRow and UnhideColumn methods of the Cells collection, respectively. Both methods take two parameters:

• Row or column index – the index of the row or column that is to be shown.
• Row height or column width – the height or width to assign to the row or column after unhiding.

When making a hidden column visible, if you need to restore it to its previously assigned width—or to its original width—please unhide the column with a negative width. For example: worksheet.Cells.UnhideColumn(5, -1)

Hiding Multiple Rows and Columns

Developers can hide multiple rows or columns at once by calling the HideRows and HideColumns methods of the Cells collection, respectively. Both methods take the starting row or column index and the number of rows or columns that should be hidden as parameters.

It is also possible to use the Cells class’s UnhideRows and UnhideColumns methods to make multiple rows and columns visible.