//create a new workbook Workbook workbook = new Workbook(); workbook.open(this.getResourceStream("xlsx/PageSetup Demo.xlsx")); IWorksheet worksheet = workbook.getWorksheets().get(0); //Set page headerfooter worksheet.getPageSetup().setLeftHeader("&\"Arial,Italic\"LeftHeader"); worksheet.getPageSetup().setCenterHeader("&P"); //Set page headerfooter's graphic worksheet.getPageSetup().setCenterFooter("&G"); InputStream stream = this.getResourceStream("logo.png"); worksheet.getPageSetup().getCenterFooterPicture().setGraphicStream(stream, ImageType.PNG); //If you have picture resources locally, you can also set graphic in this way. //worksheet.getPageSetup().setCenterFooter("&G"); //worksheet.getPageSetup().getCenterFooterPicture().setFilename("C:\\picture.png"); //worksheet.PageSetup.CenterFooterPicture.Filename = @"C:\picture.png"; //save to an excel file workbook.save("ConfigHeaderFooter.xlsx");
//create a new workbook var workbook = Workbook() workbook.open(this.getResourceStream("xlsx/PageSetup Demo.xlsx")!!) val worksheet = workbook.worksheets.get(0) //Set page headerfooter worksheet.pageSetup.leftHeader = "&\"Arial,Italic\"LeftHeader" worksheet.pageSetup.centerHeader = "&P" //Set page headerfooter's graphic worksheet.pageSetup.centerFooter = "&G" val stream = this.getResourceStream("logo.png") worksheet.pageSetup.centerFooterPicture.setGraphicStream(stream, ImageType.PNG) //If you have picture resources locally, you can also set graphic in this way. //worksheet.getPageSetup().setCenterFooter("&G"); //worksheet.getPageSetup().getCenterFooterPicture().setFilename("C:\\picture.png"); //worksheet.PageSetup.CenterFooterPicture.Filename = @"C:\picture.png"; //save to an excel file workbook.save("ConfigHeaderFooter.xlsx")