Custom function library to generate the following 1D and 2D barcodes using autoshapes:
| Barcode Type | Barcodes |
|---|---|
| 1D Code | Code 11, Code 39, Code 93, Code 128 |
| 1D UPC/EAN | EAN-2, EAN-5, EAN-8, EAN-13, UPC-A, UPC-E |
| 1D ITF | ITF, ITF-14 |
| 2D Barcodes | Aztec, Data Matrix, PDF417, QR Code |
Microsoft Excel 2013+
- Download 'Barcode Fx Library Add-In 3.0.xlam'
- Follow these instructions from Microsoft
- The functions are located under the 'Formulas' tab under the 'Barcode Function Library' group (see images).
- All check digits are auto-calculated.
| Function Name | Data Types | Length | Author |
|---|---|---|---|
Aztec() | ASCII | Unlimited | Alois Zingl |
Code11() | Numeric and dash | Unlimited | Eszopicoder |
Code39() | Alphanumeric and -$%./+ | Unlimited | Eszopicoder |
Code93() | Alphanumeric and -$%./+ | Unlimited + 2 check digits | Eszopicoder |
Code128() | ASCII | Unlimited | Alois Zingl |
DataMatrix() | ASCII | Unlimited | Alois Zingl |
EAN_2() | Numeric | 2 digits | Eszopicoder |
EAN_5() | Numeric | 5 digits | Eszopicoder |
EAN_13() | Numeric | 12 digits + check digit | Eszopicoder |
ITF() | Numeric | Unlimited | Eszopicoder |
ITF_14() | Numeric | 13 digits + check digit | Eszopicoder |
PDF_417() | ASCII | Unlimited | Grandzebu |
QRCode() | ASCII | Unlimited | Alois Zingl |
UPCA() | Numeric | 11 + check digit (UPC-A) or 8 digits (EAN-8) | Eszopicoder |
UPCE() | Numeric | ("0" or "1") + 6 digits | Eszopicoder |
