// Create a new workbook Workbook workbook = new Workbook(); InputStream fileStream = this.getResourceStream("xlsx/PageSetup Demo.xlsx"); workbook.open(fileStream); IWorksheet worksheet = workbook.getWorksheets().get(0); worksheet.getRange("C3").setValue("The page numbers and the total page numbers are added by 1."); // Set page headerfooter. // Use &P+1 to display the page number plus one. // Use &N+1 to display the total page number plus one. worksheet.getPageSetup().setRightHeader("Page header example &P+1 of &N+1 "); // Save to a pdf file workbook.save("ConfigHeaderPageNumberCalc.pdf");