//create a new workbook Workbook workbook = new Workbook(); workbook.open(this.getResourceStream("xlsx/PageSetup Demo.xlsx")); IWorksheet worksheet = workbook.getWorksheets().get(0); worksheet.getPageSetup().setCenterFooter("&P"); //Set first page number, default is p1. worksheet.getPageSetup().setFirstPageNumber(3); //save to an excel file workbook.save("ConfigFirstPageNumber.xlsx");
//create a new workbook var workbook = Workbook() workbook.open(this.getResourceStream("xlsx/PageSetup Demo.xlsx")!!) val worksheet = workbook.worksheets.get(0) worksheet.pageSetup.centerFooter = "&P" //Set first page number, default is p1. worksheet.pageSetup.firstPageNumber = 3 //save to an excel file workbook.save("ConfigFirstPageNumber.xlsx")