The Encodian population engine supports the dynamic creation and insertion of barcodes and QR codes into an Excel spreadsheet.
Spreadsheet Preparation
When using the barcode token you must add the token inside a text box, please follow this instruction:
Expression Format
The barcode token format:
<<barcode [name] -barcodeType>>
Barcode Types
The following barcode types are supported:
Type | Description |
codabar | CODABAR Barcode |
code11 | CODE 11 barcode |
code39S | Standard CODE 39 barcode |
code39E | Extended CODE 39 barcode |
code93S | Standard CODE 93 barcode |
code93E | Extended CODE 93 barcode |
code128 | CODE 128 barcode |
code128GS1 | GS1 CODE 128 barcode specification. The barcode text must contain parentheses for A |
ean8 | EAN-8 barcode |
ean13 | EAN-13 barcode |
ean14 | EAN-14 barcode |
scc14 | SCC-14 barcode |
sscc18 | SSCC-18 barcode |
upca | UPC-A barcode |
upce | UPC-E barcode |
isbn | ISBN barcode |
issn | ISSN barcode |
ismn | ISMN barcode |
stf | Standard 2 of 5 barcode |
itf | Interleaved 2 of 5 barcode |
mtf | Matrix 2 of 5 barcode |
ip25 | Italian Post 25 barcode |
iatatf | IATA 2 of 5 barcode. IATA (International Air Transport Assosiation) uses this barcode for the management of air cargo |
itf14 | ITF14 barcode |
itf6 | ITF-6 barcode |
msi | MSI Plessey barcode |
vin | VIN (Vehicle Identification Number) barcode |
dpi | Deutschen Post barcode, also known as Identcode, CodeIdentcode, German Postal 2 of 5 Identcode, Deutsche Post AG Identcode, Deutsche Frachtpost Identcode, Deutsche Post AG (DHL) |
dpl | Deutsche Post Leitcode barcode, also known as German Postal 2 of 5 Leitcode, CodeLeitcode, Leitcode, Deutsche Post AG (DHL) |
opc | OPC (Optical Product Code) barcode, also known as VCA barcode, VCA OPC, Vision Council of America OPC barcode |
pzn | PZN barcode, also known as Pharma Zentral Nummer, Pharmazentralnummer |
code16K | Code 16K barcode |
pharmacode | Represents Pharmacode barcode, also known as Code32 |
dm | DataMatrix barcode |
qr | QR Code barcode |
aztec | Aztec barcode |
pdf417 | Pdf417 barcode |
macroPdf417 | MacroPdf417 barcode |
dmGS1 | DataMatrix barcode with GS1 string format |
microPdf417 | MicroPdf417 barcode |
qrGS1 | QR barcode with GS1 string format |
maxiCode | MaxiCode barcode |
dotCode | DotCode barcode |
ap | Australia Post Customer barcode |
postnet | Postnet barcode |
planet | Planet barcode |
oneCode | USPS OneCode barcode |
rm4scc | RM4SCC barcode. RM4SCC (Royal Mail 4-state Customer Code) is used for automated mail sort process in UK |
databarOD | Databar omni-directional barcode |
databarT | Databar truncated barcode |
databarL | Databar limited barcode |
databarE | Databar expanded barcode |
databarES | Databar expanded stacked barcode |
databarS | Databar stacked barcode |
databarSOD | Databar stacked omni-directional barcode |
sp | Singapore Post barcode |
ape | Australian Post Domestic eParcel barcode |
spp | Swiss Post Parcel barcode. Supported types: Domestic Mail, International Mail, Additional Services |
patchCode | Patch code barcode |
code32 | Code32 barcode |
dltf | DataLogic 2 of 5 barcode |
dkix | Dutch KIX barcode |
codablockF | Codablock F barcode |
codablockFGS1 | GS1 Codablock F barcode |
code128GS1UPCA | GS1-128 AI 8102 Coupon Extended barcode |
databarGS1UPCA | UPCA & GS1 Databar Coupon barcode |
Generate Barcode - Basic
Please ensure you have followed the Spreadsheet Preparation steps.
Example Spreadsheet: Encodian - Template Syntax - Barcode Basic.xlsx
Example JSON Data:
{
"value":"123456789"
}
The barcode token is configured to generate a codabar barcode
<<barcode [value] -codabar>>
This generates the following output:
Format - Barcode Fore Color and Background Color
The color used as the primary barcode color is designated by the font color applied to the barcode token. The color used as the background of the barcode is designated by the fill color applied to the text box.
Format - Barcode Font
The font format used for the barcode text is designated by the font styles applied to the barcode token.
Generate Barcode - Formatted
Please ensure you have followed the Spreadsheet Preparation steps.
Example Spreadsheet: Encodian - Template Syntax - Barcode Formatted.xlsx
Example JSON Data:
{
"value":"123456789"
}
The barcode token is configured to generate a codabar barcode
<<barcode [value] -codabar>>
This generates the following output:
Troubleshooting
Text Box Size
You must ensure that the text box containing the barcode token is large enough for the barcode image generated, if it isn't these types of errors will be thrown:
0 Comments