Custom function library to generate the following 1D barcodes using =SPARKLINE():
Barcode Type
Barcodes
Status
1D Code
Code 11, Code 39, Code 93, Code 128
In progress
1D UPC/EAN
EAN-2, EAN-5, EAN-8, EAN-13, UPC-A, UPC-E
Completed
1D ITF
ITF, ITF-14
Completed
How It Works
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)
Installation and Usage
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.