// Create a new workbook Workbook workbook = new Workbook(); workbook.open(this.getResourceStream("xlsx/PageSetup Demo.xlsx")); IWorksheet worksheet = workbook.getWorksheets().get(0); //Set sheet worksheet.getPageSetup().setPrintGridlines(true); worksheet.getPageSetup().setPrintHeadings(true); worksheet.getPageSetup().setBlackAndWhite(true); worksheet.getPageSetup().setPrintComments(PrintLocation.InPlace); worksheet.getPageSetup().setPrintErrors(PrintErrors.Dash); // Save to an excel file workbook.save("ConfigSheetPrintSettings.xlsx");