// Create a new workbook Workbook workbook = new Workbook(); //set worksheet layout and data IWorksheet worksheet = workbook.getWorksheets().get(0); worksheet.getRange("B:C").setColumnWidth(15); worksheet.getRange("D:G").setColumnWidth(20); worksheet.getRange("4:7").setRowHeight(60); worksheet.getRange("A:A").setColumnWidth(5); worksheet.getRange("B2").setValue("EAN-13"); worksheet.getRange("B2:F2").setMergeCells(true); worksheet.getRange("B3:G3").setValue(new Object[][] { {"Name", "Number", "Default", "Change addOn", "Change addOnLabelPosition", "Explain"} }); 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:C6").setValue(new Object[][] { {"Medicine", "692031229621"}, {"Pen", "6945091701532"}, {"value length is 13", "8142486545683"} }); worksheet.getRange("G6").setValue("No EAN-13 generated, because the last digit is check-sum digit and it is invalid"); worksheet.getRange("G6").getFont().setColor(Color.GetRed()); 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 < 7; i++) { worksheet.getRange("D" + i).setFormula("=BC_EAN13" + "(C" + i + ")"); worksheet.getRange("E" + i).setFormula("=BC_EAN13" + "(C" + i + ",,,,,22)"); worksheet.getRange("F" + i).setFormula("=BC_EAN13" + "(C" + i + ",,,,,22,\"bottom\")"); } // Save to a pdf file workbook.save("EAN13.pdf");