//create a new workbook Workbook workbook = new Workbook(); workbook.open(this.getResourceStream("xlsx/PageSetup Demo.xlsx")); IWorksheet worksheet = workbook.getWorksheets().get(0); //Set print area & print titles worksheet.getPageSetup().setPrintArea("$D$5:$G$10"); worksheet.getPageSetup().setPrintTitleRows("$5:$10"); worksheet.getPageSetup().setPrintTitleColumns("$D:$G"); //save to an excel file workbook.save("ConfigPrintArea.xlsx");
//create a new workbook var workbook = Workbook() workbook.open(this.getResourceStream("xlsx/PageSetup Demo.xlsx")!!) val worksheet = workbook.worksheets.get(0) //Set print area & print titles worksheet.pageSetup.printArea = "\$D$5:\$G$10" worksheet.pageSetup.printTitleRows = "$5:$10" worksheet.pageSetup.printTitleColumns = "\$D:\$G" //save to an excel file workbook.save("ConfigPrintArea.xlsx")