// 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");