Code49
In This Topic
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.
A screenshot depicting Code49 barcode sparkline is shared below.
Formula definition
You can set Code49 sparkline 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 sparkline in the worksheet.
| JavaScript |
Copy Code
|
|---|---|
var sheet = spread.getActiveSheet(); // Set Code49 Barcode Sparkline sheet.setValue(3, 1, "Code49", GC.Spread.Sheets.SheetArea.viewport); sheet.setValue(3, 2, "6901668002433", GC.Spread.Sheets.SheetArea.viewport); // Set Style sheet.setRowHeight(3, 100); for (var col = 1; col < 4; col++) { sheet.setColumnWidth(col, 200); } sheet.getRange(3, 0, 1, 4).hAlign(GC.Spread.Sheets.HorizontalAlign.center); sheet.getRange(3, 0, 1, 4).vAlign(GC.Spread.Sheets.VerticalAlign.center); // Set Formula sheet.setFormula(3, 3, '=BC_CODE49(C4)'); |
|