//create a new workbook Workbook workbook = new Workbook(); workbook.open(this.getResourceStream("xlsx/PageSetup Demo.xlsx")); IWorksheet worksheet = workbook.getWorksheets().get(0); //Set margins, in points. worksheet.getPageSetup().setTopMargin(36); worksheet.getPageSetup().setBottomMargin(36); worksheet.getPageSetup().setRightMargin(72); //save to an excel file workbook.save("ConfigPageMargins.xlsx");
//create a new workbook var workbook = Workbook() workbook.open(this.getResourceStream("xlsx/PageSetup Demo.xlsx")!!) val worksheet = workbook.worksheets.get(0) //Set margins, in points. worksheet.pageSetup.topMargin = 36.0 worksheet.pageSetup.bottomMargin = 36.0 worksheet.pageSetup.rightMargin = 72.0 //save to an excel file workbook.save("ConfigPageMargins.xlsx")