// Create a new workbook Workbook workbook = new Workbook(); //set worksheet layout and data IWorksheet worksheet = workbook.getWorksheets().get(0); worksheet.getRange("B:F").setColumnWidth(15); worksheet.getRange("4:7").setRowHeight(60); worksheet.getRange("A:A").setColumnWidth(5); worksheet.getRange("B2").setValue("Data Matrix"); worksheet.getRange("B2:F2").setMergeCells(true); worksheet.getRange("B3:F3").setValue(new Object[][] { {"Server", "Data", "Default", "ECC100", "ECC200"} }); 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:B7").setWrapText(true); worksheet.getPageSetup().setPrintGridlines(true); //set formula for (int i = 4; i < 8; i++) { String value = "CONCAT(B" + i + ",\":\",C" + i + ")"; worksheet.getRange("D" + i).setFormula("=BC_DataMatrix" + "(" + value + ")"); worksheet.getRange("E" + i).setFormula("=BC_DataMatrix" + "(" + value + ", , ,\"ECC000\")"); worksheet.getRange("F" + i).setFormula("=BC_DataMatrix" + "(" + value + ", , ,\"ECC200\")"); } // Save to a pdf file workbook.save("DataMatrix.pdf");
// Create a new workbook var workbook = Workbook() //set worksheet layout and data val worksheet = workbook.worksheets.get(0) worksheet.getRange("B:F").columnWidth = 15.0 worksheet.getRange("4:7").rowHeight = 60.0 worksheet.getRange("A:A").columnWidth = 5.0 worksheet.getRange("B2").value = "Data Matrix" worksheet.getRange("B2:F2").mergeCells = true worksheet.getRange("B3:F3").value = arrayOf(arrayOf("Server", "Data", "Default", "ECC100", "ECC200")) 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:B7").wrapText = true worksheet.pageSetup.printGridlines = true //set formula for (i in 4..7) { val value = "CONCAT(B$i,\":\",C$i)" worksheet.getRange("D$i").formula = "=BC_DataMatrix($value)" worksheet.getRange("E$i").formula = "=BC_DataMatrix($value, , ,\"ECC000\")" worksheet.getRange("F$i").formula = "=BC_DataMatrix($value, , ,\"ECC200\")" } // Save to a pdf file workbook.save("DataMatrix.pdf")