Hide and Unhide Cells

Aspose.Cells - Hide and Unhide 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 for managing rows or columns in a worksheet. 

Java

 Workbook workbook = new Workbook("workbook.xls");
 
 //Accessing the first worksheet in the Excel file
 
 Worksheet worksheet = workbook.getWorksheets().get(0);
 
 Cells cells = worksheet.getCells();
 
 cells.hideRow(2); //Hiding the 3rd row of the worksheet
 
 cells.hideColumn(1); //Hiding the 2nd column of the worksheet
 

Apache POI SS - HSSF XSSF - Hide / Unhide Cells

To hide a row or column, Apache POI SS provides the Row.setZeroHeight(boolean) method.

Java

 InputStream inStream = new FileInputStream("workbook.xls");
 
 Workbook workbook = WorkbookFactory.create(inStream);
 
 Sheet sheet = workbook.createSheet();
 
 Row row = sheet.createRow(0);
 
 row.setZeroHeight(true);
 

Download Running Code

• GitHub

Download Sample Code

• GitHub

For more details, visit Hiding and Showing Rows and Columns.