// Create a new workbook Workbook workbook = new Workbook(); IWorksheet worksheet = workbook.getWorksheets().get(0); worksheet.getRange("E1").setValue(1); //Hidden row 2:6. worksheet.getRange("2:6").setHidden(true); //Hidden column A:D. worksheet.getRange("A:D").setHidden(true); // Save to an excel file workbook.save("HiddenRowColumn.xlsx");