// Create a new workbook Workbook workbook = new Workbook(); workbook.open(this.getResourceStream("xlsx/ConfigIsAutoFirstPageNumber.xlsx")); IWorksheet worksheet = workbook.getWorksheets().get(0); worksheet.getPageSetup().setCenterFooter("&P"); //Set auto page number, original first page number is 3. worksheet.getPageSetup().setIsAutoFirstPageNumber(true); // Save to an excel file workbook.save("SetIsAutoFirstPageNumber.xlsx");
// Create a new workbook var workbook = Workbook() workbook.open(this.getResourceStream("xlsx/ConfigIsAutoFirstPageNumber.xlsx")!!) val worksheet = workbook.worksheets.get(0) worksheet.pageSetup.centerFooter = "&P" //Set auto page number, original first page number is 3. worksheet.pageSetup.isAutoFirstPageNumber = true // Save to an excel file workbook.save("SetIsAutoFirstPageNumber.xlsx")