Generate Barcodes and QR Codes

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:

2024-06-27_15-24-43.gif

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:

Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.
Powered by Zendesk