//create a new workbook Workbook workbook = new Workbook(); workbook.open(this.getResourceStream("xlsx/PageSetup Demo.xlsx")); IWorksheet worksheet = workbook.getWorksheets().get(0); //Set center, default is false. worksheet.getPageSetup().setCenterHorizontally(true); worksheet.getPageSetup().setCenterVertically(true); //save to an excel file workbook.save("ConfigPageCenter.xlsx");
//create a new workbook var workbook = Workbook() workbook.open(this.getResourceStream("xlsx/PageSetup Demo.xlsx")!!) val worksheet = workbook.worksheets.get(0) //Set center, default is false. worksheet.pageSetup.centerHorizontally = true worksheet.pageSetup.centerVertically = true //save to an excel file workbook.save("ConfigPageCenter.xlsx")