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("Javatpoint.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.