Custom function library to generate the following 1D barcodes using =SPARKLINE():
| Barcode Type | Barcodes | Status |
|---|---|---|
| 1D Code | Code 11, Code 39, Code 93, |
In progress |
| 1D UPC/EAN | EAN-2, EAN-5, EAN-8, EAN-13, UPC-A, UPC-E | Completed |
| 1D ITF | ITF, ITF-14 | Completed |
- Barcode generation is performed by repurposing
=SPARKLINE()using the following options{"charttype","bar";"color1","black";"color2","white"} - The individual barcode functions return an array indicating the width of the alternating bars (black) and spaces (white)
- To install, you can manually copy/paste the code into the Google Apps Script Editor
- To install as a library in the Google Apps Script Editor, follow these instructions using script ID: 1UudrKNziZj_sKPi_L_Bmav9vnvCJKB3QOpffaakWv5x4VBJcK-kOxOpR
- Use the following function template to generate barcodes:
=SPARKLINE(ITF(INSERT BARCODE HERE),BarcodeOpt()) - All check digits are auto-calculated if not included and verified if included.
| Function Name | Data Types | Length and Format | Check Digit |
|---|---|---|---|
Code11() |
Numeric and dash | Unlimited | None |
Code39() |
Uppercase alphanumeric, space, and -$%./+ | Unlimited + check digit (optional) | Modulo 43 |
Code93() |
Uppercase alphanumeric, space, and -$%./+ | Unlimited + 2 check digits | Modulo 47 |
EAN_2() |
Numeric | 2 digits | None |
EAN_5() |
Numeric | 5 digits | None |
EAN_13() |
Numeric | 12 digits + check digit | GS1 check digit |
ITF() |
Numeric | Unlimited | None |
ITF_14() |
Numeric | 13 digits + check digit | GS1 check digit |
UPCA() |
Numeric | 11 + check digit (UPC-A) or 8 digits (EAN-8) | GS1 check digit |
UPCE() |
Numeric | ("0" or "1") + 6 digits | None |
