Export Barcodes

// Create a new workbook.
Workbook workbook = new Workbook();

// Set worksheet layout and data.
IWorksheet worksheet = workbook.getWorksheets().get(0);
worksheet.getRange("A:A").setColumnWidth(2);
worksheet.getRange("B:C").setColumnWidth(15);
worksheet.getRange("D:G").setColumnWidth(25);
worksheet.getRange("4:14").setRowHeight(57);
worksheet.getRange("B3").setValue("Type");
worksheet.getRange("C3").setValue("Data");
worksheet.getRange("B2").setValue("Barcode");
worksheet.getRange("B2:G2").merge(true);
worksheet.getRange("D3:G3").setValue(new Object[][]{{"Default", "Change color", "Change showLable", "Change lablePosition"}});
worksheet.getPageSetup().setPrintTitleColumns("$A:$C");
worksheet.getRange("B4:C14").setHorizontalAlignment(HorizontalAlignment.Center);
worksheet.getRange("B4:C14").setVerticalAlignment(VerticalAlignment.Center);
worksheet.getRange("B2:G3").setHorizontalAlignment(HorizontalAlignment.Center);
worksheet.getRange("B2:G3").setVerticalAlignment(VerticalAlignment.Center);
worksheet.getRange("B4:C14").setValue(new Object[][]{
        {"QR code", "Policy:411"},
        {"Data Matrix", "Policy:411"},
        {"PDF417", 6935205311092L},
        {"EAN-8", 4137962},
        {"EAN-13", 6920312296219L},
        {"Code39", 3934712708295L},
        {"Code93", 6945091701532L},
        {"Code49", 6901668002433L},
        {"Code128", 465465145645L},
        {"Codabar", 9787560044231L},
        {"gs1128", 235465143135L}
});
String[] types = {
        "BC_QRCODE",
        "BC_DataMatrix",
        "BC_PDF417",
        "BC_EAN8",
        "BC_EAN13",
        "BC_CODE39",
        "BC_CODE93",
        "BC_CODE49",
        "BC_CODE128",
        "BC_CODABAR",
        "BC_GS1_128"};
worksheet.getPageSetup().setPrintGridlines(true);

// Use formula to add barcode.
for (int i = 0; i < types.length; i++) {
        String columnD = "D" + (i + 4);
        String columnE = "E" + (i + 4);
        worksheet.getRange(columnD).setFormula("=" + types[i] + "(C" + (i + 4) + ")");
        worksheet.getRange(columnE).setFormula("=" + types[i] + "(C" + (i + 4) + ",\"#fff\",\"#000\")");
}

for (int i = 3; i < types.length; i++) {
        String columnD = "F" + (i + 4);
        String columnE = "G" + (i + 4);
        worksheet.getRange(columnD).setFormula("=" + types[i] + "(C" + (i + 4) + ",,,0)");
        worksheet.getRange(columnE).setFormula("=" + types[i] + "(C" + (i + 4) + ",,,,\"top\")");
}

// Save to a pdf file.
workbook.save("ExportExcelBarcodesToPDF.pdf");