//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");
//create a new workbook var workbook = Workbook() workbook.open(this.getResourceStream("xlsx/PageSetup Demo.xlsx")!!) val worksheet = workbook.worksheets.get(0) //Set sheet worksheet.pageSetup.printGridlines = true worksheet.pageSetup.printHeadings = true worksheet.pageSetup.blackAndWhite = true worksheet.pageSetup.printComments = PrintLocation.InPlace worksheet.pageSetup.printErrors = PrintErrors.Dash //save to an excel file workbook.save("ConfigSheetPrintSettings.xlsx")