Apache POI Hiding Rows

by Online Tutorials Library July 14, 2022

Apache POI Hiding Rows

Using Apache POI, it is possible to hide a row. To hide the row, we can call setZeroHeight() method on the instance of row. This method takes argument either true or false. If the value is true, it will hide the row and unhide the row if value is set false.

Lets see an example in which we are creating a row and hiding it by passing True literal.

Apache POI Hiding Rows Example

  package poiexample;  import java.io.FileOutputStream;  import java.io.OutputStream;  import org.apache.poi.hssf.usermodel.HSSFWorkbook;  import org.apache.poi.ss.usermodel.Cell;  import org.apache.poi.ss.usermodel.Row;  import org.apache.poi.ss.usermodel.Sheet;  import org.apache.poi.ss.usermodel.Workbook;  public class HideExample {  public static void main(String[] args) {  try (OutputStream os = new FileOutputStream(“tutoraspire.xls”)) {  Workbook workbook = new HSSFWorkbook();      Sheet sheet = workbook.createSheet();      Row row = sheet.createRow(0);      Cell cell = row.createCell(0);      cell.setCellValue(“102”);      row.setZeroHeight(false);      workbook.write(os);  }catch(Exception e) {  System.out.println(e.getMessage());  }  }  }  

Output:

If we set setZeroHeight false, it does not hide the row and shows the following output.

If we set setZeroHeight True, it hides the row and shows the following output.

See, it hides first rows and sheet starts from second row.

Next TopicApache POI Cell Properties

Apache POI Hiding Rows

Apache POI Hiding Rows

Apache POI Hiding Rows Example

Apache Cordova Tutorial

Updating the Document Using XML in Apache Solr

You may also like