//create a new workbook Workbook workbook = new Workbook(); workbook.open(this.getResourceStream("xlsx/PageSetup Demo.xlsx")); IWorksheet worksheet = workbook.getWorksheets().get(0); //Set paper scaling //Method 1: Set percent scale worksheet.getPageSetup().setIsPercentScale(true); worksheet.getPageSetup().setZoom(150); //Or Method 2: Fit to page's wide & tall //worksheet.getPageSetup().setIsPercentScale(false); //worksheet.getPageSetup().setFitToPagesWide(3); //worksheet.getPageSetup().setFitToPagesTall(4); //save to an excel file workbook.save("ConfigPaperScaling.xlsx");
//create a new workbook var workbook = Workbook() workbook.open(this.getResourceStream("xlsx/PageSetup Demo.xlsx")!!) val worksheet = workbook.worksheets.get(0) //Set paper scaling //Method 1: Set percent scale worksheet.pageSetup.isPercentScale = true worksheet.pageSetup.zoom = 150 //Or Method 2: Fit to page's wide & tall //worksheet.getPageSetup().setIsPercentScale(false); //worksheet.getPageSetup().setFitToPagesWide(3); //worksheet.getPageSetup().setFitToPagesTall(4); //save to an excel file workbook.save("ConfigPaperScaling.xlsx")