Code49

Code 49 is a two dimensional, high-density stacked barcode with two to eight rows (having eight characters each). Each row has a start code and a stop code. This barcode is especially used to encodes the complete ASCII character set.

The below image displays Code49 barcode in a PDF document.

Formula definition

You can set Code49 in a worksheet using the following formula:

=BC_CODE49(value, color, backgroudColor, showLabel, labelPosition, grouping, groupNo, fontFamily, fontStyle, fontWeight, fontTextDecoration, fontTextAlign, fontSize, quietZoneLeft, quietZoneRight, quietZoneTop, quietZoneBottom)

Parameter

Name	Description
value	A string that represents encode on the symbol of QRCode.
color	A color that represents the barcode color. The default value is 'rgb(0,0,0)'.
backgroundColor	A color that represents the barcode backgroundcolor. The default value is 'rgb(255, 255, 255)'
showLabel	Specifies whether to show label text when the barcode has label.
labelPosition	?A value that represents the label position when the label is shown.
grouping	Specifies whether the symbol mode is Group Alphanimeric Mode. The default value is 'false'.
groupNo	A value that represents the index of symbol in the group. The default value is '0'
fontFamily	A string that represents the label text fontFamily. The default value is 'sans-serif'.
fontStyle	A string that represents the label text fontStyle. The default value is 'normal'.
fontWeight	A string that represents the label text fontWeight. The default value is 'normal'.
fontTextDecoration	A string that represents the label text fontTextDecoration. The default value is 'none'.
fontTextAlign	A string that represents the label text fontTextAlign. The default value is 'center'.
fontSize	A string that represents the label text fontSize. The default value is '12px'.
quietZoneLeft	A value that represents the size of left quiet zone.
quietZoneRight	A value that represents the size of right quiet zone.
quietZoneTop	A value that represents the size of top quiet zone.
quietZoneBottom	A value that represents the size of bottom quiet zone.

Using Code

This example code sets Code49 in the worksheet.

// Create a new workbook
Workbook workbook = new Workbook();
// Set worksheet layout and data
IWorksheet worksheet = workbook.getWorksheets().get(0);
worksheet.getRange("B:C").setColumnWidth(10);
worksheet.getRange("D:F").setColumnWidth(30);
worksheet.getRange("4:5").setRowHeight(80);
worksheet.getRange("A:A").setColumnWidth(5);
worksheet.getRange("B2").setValue("Code49");
worksheet.getRange("B2:F2").setMergeCells(true);
worksheet.getRange("B3:G3").setValue(new Object[][]
{
    {"Name", "Number", "Default", "Customer Label Font", "Line Through Label"}
});
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:C5").setValue(new Object[][]
{
    {"Police", "911"},
    {"Travel Info Call 511", "511"}
});
worksheet.getRange("B4:C6").setWrapText(true);
worksheet.getRange("G6").setWrapText(true);
worksheet.getPageSetup().setPrintGridlines(true);
worksheet.getPageSetup().setOrientation(PageOrientation.Landscape);

// Set formula
for (int i = 4; i < 6; i++)
{
    String value = "CONCAT(B" + i + ", \": \",C" + i + ")";
    worksheet.getRange("D" + i).setFormula("=BC_CODE49" + "(" + value + ")");
    worksheet.getRange("E" + i).setFormula("=BC_CODE49" + "(" + value + ", , , true, \"top\", false, 0, \"Arial\", \"normal\", 700)");
    worksheet.getRange("F" + i).setFormula("=BC_CODE49" + "(" + value + ", , , , , , , , , 700, \"line - through\", \"left\", \"24px\")");
}
        
String jsonstr = workbook.toJson();
System.out.println(jsonstr);
        
// Save to an pdf file
workbook.save("Code49.pdf");

Formula definition
Parameter
Using Code