//create a new workbook Workbook workbook = new Workbook(); workbook.open(this.getResourceStream("xlsx/PageSetup Demo.xlsx")); IWorksheet worksheet = workbook.getWorksheets().get(0); //Set first page headerfooter worksheet.getPageSetup().setDifferentFirstPageHeaderFooter(true); worksheet.getPageSetup().getFirstPage().getCenterHeader().setText("&T"); worksheet.getPageSetup().getFirstPage().getRightFooter().setText("&D"); //Set first page headerfooter's graphic worksheet.getPageSetup().getFirstPage().getLeftFooter().setText("&G"); InputStream stream = this.getResourceStream("logo.png"); worksheet.getPageSetup().getFirstPage().getLeftFooter().getPicture().setGraphicStream(stream, ImageType.PNG); worksheet.getPageSetup().getFirstPage().getLeftFooter().getPicture().setWidth(100); worksheet.getPageSetup().getFirstPage().getLeftFooter().getPicture().setHeight(13); //save to an excel file workbook.save("ConfigFirstPageHeaderFooter.xlsx");
//create a new workbook var workbook = Workbook() workbook.open(this.getResourceStream("xlsx/PageSetup Demo.xlsx")!!) val worksheet = workbook.worksheets.get(0) //Set first page headerfooter worksheet.pageSetup.differentFirstPageHeaderFooter = true worksheet.pageSetup.firstPage.centerHeader.text = "&T" worksheet.pageSetup.firstPage.rightFooter.text = "&D" //Set first page headerfooter's graphic worksheet.pageSetup.firstPage.leftFooter.text = "&G" val stream = this.getResourceStream("logo.png") worksheet.pageSetup.firstPage.leftFooter.picture.setGraphicStream(stream, ImageType.PNG) worksheet.pageSetup.firstPage.leftFooter.picture.width = 100.0 worksheet.pageSetup.firstPage.leftFooter.picture.height = 13.0 //save to an excel file workbook.save("ConfigFirstPageHeaderFooter.xlsx")