// Create a new workbook Workbook workbook = new Workbook(); //set worksheet layout and data IWorksheet worksheet = workbook.getWorksheets().get(0); worksheet.getRange("B:F").setColumnWidth(20); worksheet.getRange("4:7").setRowHeight(60); worksheet.getRange("A:A").setColumnWidth(5); worksheet.getRange("B2").setValue("Code128"); worksheet.getRange("B2:F2").setMergeCells(true); worksheet.getRange("B3:F3").setValue(new Object[][] { {"Name", "Number", "Default", "Hidden Label", "Custom Label Font"} }); worksheet.getRange("B4:C7").setHorizontalAlignment(HorizontalAlignment.Center); worksheet.getRange("B4:C7").setVerticalAlignment(VerticalAlignment.Center); worksheet.getRange("B2:F3").setHorizontalAlignment(HorizontalAlignment.Center); worksheet.getRange("B2:F3").setVerticalAlignment(VerticalAlignment.Center); worksheet.getRange("B4:C7").setValue(new Object[][] { {"Police", 911}, {"Telephone Directory Assistance", 411}, {"Non-emergency Municipal Services", 311}, {"Travel Info Call 511", 511} }); worksheet.getRange("B4:C6").setWrapText(true); worksheet.getRange("G6").setWrapText(true); worksheet.getPageSetup().setOrientation(PageOrientation.Landscape); worksheet.getPageSetup().setPrintGridlines(true); //set formula for (int i = 4; i < 8; i++) { worksheet.getRange("D" + i).setFormula("=BC_CODE128" + "(C" + i + ")"); worksheet.getRange("E" + i).setFormula("=BC_CODE128" + "(C" + i + ", , , false))"); worksheet.getRange("F" + i).setFormula("=BC_CODE128" + "(C" + i + ", , , true, \"top\", \"B\",\"Arial\", \"normal\")"); } // Save to a pdf file workbook.save("Code128.pdf");
// Create a new workbook var workbook = Workbook() //set worksheet layout and data val worksheet = workbook.worksheets.get(0) worksheet.getRange("B:F").columnWidth = 20.0 worksheet.getRange("4:7").rowHeight = 60.0 worksheet.getRange("A:A").columnWidth = 5.0 worksheet.getRange("B2").value = "Code128" worksheet.getRange("B2:F2").mergeCells = true worksheet.getRange("B3:F3").value = arrayOf(arrayOf("Name", "Number", "Default", "Hidden Label", "Custom Label Font")) worksheet.getRange("B4:C7").horizontalAlignment = HorizontalAlignment.Center worksheet.getRange("B4:C7").verticalAlignment = VerticalAlignment.Center worksheet.getRange("B2:F3").horizontalAlignment = HorizontalAlignment.Center worksheet.getRange("B2:F3").verticalAlignment = VerticalAlignment.Center worksheet.getRange("B4:C7").value = arrayOf(arrayOf("Police", 911), arrayOf("Telephone Directory Assistance", 411), arrayOf("Non-emergency Municipal Services", 311), arrayOf("Travel Info Call 511", 511)) worksheet.getRange("B4:C6").wrapText = true worksheet.getRange("G6").wrapText = true worksheet.pageSetup.orientation = PageOrientation.Landscape worksheet.pageSetup.printGridlines = true //set formula for (i in 4..7) { worksheet.getRange("D$i").formula = "=BC_CODE128(C$i)" worksheet.getRange("E$i").formula = "=BC_CODE128(C$i, , , false))" worksheet.getRange("F$i").formula = "=BC_CODE128(C$i, , , true, \"top\", \"B\",\"Arial\", \"normal\")" } // Save to a pdf file workbook.save("Code128.pdf")