//create a new workbook Workbook workbook = new Workbook(); IWorksheet sheet = workbook.getWorksheets().get(0); int row = 50; int column = 14; Object[][] data = new Object[row][column]; for (int i = 0; i < row; i++) { for (int j = 0; j < column; j++) { data[i][j] = "R" + i + "C" + j; } } //Set data. sheet.getRange("A1:N50").setValue(data); sheet.getRange("A2:N4").setValue("TitleRows"); sheet.getRange("A2:N4").getInterior().setColor(Color.GetGreen()); sheet.getRange("C1:E50").setValue("TitleColumns"); sheet.getRange("C1:E50").getInterior().setColor(Color.GetYellow()); sheet.getPageSetup().setPrintHeadings(true); //Set print titles. sheet.getPageSetup().setPrintTitleRows("$2:$4"); sheet.getPageSetup().setPrintTitleColumns("$C:$E"); //save to an pdf file workbook.save("ConfigurePrintTitles.pdf");
//create a new workbook var workbook = Workbook() val sheet = workbook.worksheets.get(0) val row = 50 val column = 14 val data = Array>(row) { arrayOfNulls(column) } for (i in 0 until row) { for (j in 0 until column) { data[i][j] = "R" + i + "C" + j } } //Set data. sheet.getRange("A1:N50").value = data sheet.getRange("A2:N4").value = "TitleRows" sheet.getRange("A2:N4").interior.color = Color.GetGreen() sheet.getRange("C1:E50").value = "TitleColumns" sheet.getRange("C1:E50").interior.color = Color.GetYellow() sheet.pageSetup.printHeadings = true //Set print titles. sheet.pageSetup.printTitleRows = "$2:$4" sheet.pageSetup.printTitleColumns = "\$C:\$E" //save to an pdf file workbook.save("ConfigurePrintTitles.pdf")