//create a new workbook Workbook workbook = new Workbook(); IWorksheet sheet = workbook.getWorksheets().get(0); //Set pages' data. sheet.getRange("A1:J46").setValue("Page1"); sheet.getRange("A1:J46").getInterior().setColor(Color.GetLightGreen()); sheet.getRange("A47:J92").setValue("Page2"); sheet.getRange("A47:J92").getInterior().setColor(Color.GetLightYellow()); sheet.getRange("K1:T46").setValue("Page3"); sheet.getRange("K1:T46").getInterior().setColor(Color.GetOrangeRed()); sheet.getRange("K47:T92").setValue("Page4"); sheet.getRange("K47:T92").getInterior().setColor(Color.GetDarkOrange()); sheet.getRange("U1:AD46").setValue("Page5"); sheet.getRange("U1:AD46").getInterior().setColor(Color.GetLightBlue()); sheet.getRange("U47:AD92").setValue("Page6"); sheet.getRange("U47:AD92").getInterior().setColor(Color.GetIndianRed()); sheet.getPageSetup().setPrintHeadings(true); //Set print page range, print p1, p3 to p5. sheet.getPageSetup().setPrintPageRange("1,3-5"); //save to an pdf file workbook.save("ConfigurePrintPageRange.pdf");
//create a new workbook var workbook = Workbook() val sheet = workbook.worksheets.get(0) //Set pages' data. sheet.getRange("A1:J46").value = "Page1" sheet.getRange("A1:J46").interior.color = Color.GetLightGreen() sheet.getRange("A47:J92").value = "Page2" sheet.getRange("A47:J92").interior.color = Color.GetLightYellow() sheet.getRange("K1:T46").value = "Page3" sheet.getRange("K1:T46").interior.color = Color.GetOrangeRed() sheet.getRange("K47:T92").value = "Page4" sheet.getRange("K47:T92").interior.color = Color.GetDarkOrange() sheet.getRange("U1:AD46").value = "Page5" sheet.getRange("U1:AD46").interior.color = Color.GetLightBlue() sheet.getRange("U47:AD92").value = "Page6" sheet.getRange("U47:AD92").interior.color = Color.GetIndianRed() sheet.pageSetup.printHeadings = true //Set print page range, print p1, p3 to p5. sheet.pageSetup.printPageRange = "1,3-5" //save to an pdf file workbook.save("ConfigurePrintPageRange.pdf")