List of ConnectCode's Excel Custom Functions
- Codabar Barcode
Custom Function Name
For Barcode
=CONNECTCODE.ENCODE_CODECODABAR(PARAM1, PARAM2)
PARAM1 - Input Data
PARAM2 - 1 to generate check digit. 0 to turn off check digit.
For Human Readable Text that appears below the barcode
=CONNECTCODE.ENCODE_CODECODABAR_HRT(PARAM1, PARAM2)
PARAM1 - Input Data
PARAM2 - 1 to generate check digit. 0 to turn off check digit.
Fonts
CCodeCodabar_S1
CCodeCodabar_S2
CCodeCodabar_S3 (ConnectCodeCodabar_S3.ttf Default)
CCodeCodabar_S4
CCodeCodabar_S5
CCodeCodabar_S6
CCodeCodabar_S7
- Code 39 Barcode
Custom Function Name
For Barcode
=CONNECTCODE.ENCODE_CODE39(PARAM1, PARAM2)
PARAM1 - Input Data
PARAM2 - 1 to generate check digit. 0 to turn off check digit.
For Human Readable Text that appears below the barcode
=CONNECTCODE.ENCODE_CODE39_HRT(PARAM1, PARAM2)
PARAM1 - Input Data
PARAM2 - 1 to generate check digit. 0 to turn off check digit.
Fonts
CCodeCode39_S1
CCodeCode39_S2
CCodeCode39_S3 (ConnectCodeCode39_S3.ttf Default)
CCodeCode39_S4
CCodeCode39_S5
CCodeCode39_S6
CCodeCode39_S7
CCodeCode39_HS3 (embedded Human Readable Text)
- Code 39 ASCII (Extended) Barcode
Custom Function Name
For Barcode
=CONNECTCODE.ENCODE_CODE39ASCII(PARAM1, PARAM2)
PARAM1 - Input Data
PARAM2 - 1 to generate check digit. 0 to turn off check digit.
For Human Readable Text that appears below the barcode
=CONNECTCODE.ENCODE_CODE39ASCII_HRT(PARAM1, PARAM2)
PARAM1 - Input Data
PARAM2 - 1 to generate check digit. 0 to turn off check digit.
Fonts
CCodeCode39_S1
CCodeCode39_S2
CCodeCode39_S3 (ConnectCodeCode39_S3.ttf Default)
CCodeCode39_S4
CCodeCode39_S5
CCodeCode39_S6
CCodeCode39_S7
CCodeCode39_HS3 (embedded Human Readable Text)
- Code 93 Barcode
Custom Function Name
For Barcode
=CONNECTCODE.ENCODE_CODE93(PARAM1, PARAM2)
PARAM1 - Input Data
PARAM2 - 1 to generate check digit. 0 to turn off check digit.
For Human Readable Text that appears below the barcode
=CONNECTCODE.ENCODE_CODE93_HRT(PARAM1, PARAM2)
PARAM1 - Input Data
PARAM2 - 1 to generate check digit. 0 to turn off check digit.
Fonts
CCodeCode93_S1
CCodeCode93_S2
CCodeCode93_S3 (ConnectCodeCode93_S3.ttf Default)
CCodeCode93_S4
CCodeCode93_S5
CCodeCode93_S6
CCodeCode93_S7
- Code 128A Barcode
Custom Function Name
For Barcode
=CONNECTCODE.ENCODE_CODE128A(PARAM1)
PARAM1 - Input Data
For Human Readable Text that appears below the barcode
=CONNECTCODE.ENCODE_CODE128A_HRT(PARAM1)
PARAM1 - Input Data
Fonts
CCodeCode128_S1
CCodeCode128_S2
CCodeCode128_S3 (ConnectCodeCode128_S3.ttf Default)
CCodeCode128_S4
CCodeCode128_S5
CCodeCode128_S6
CCodeCode128_S7
- Code 128B Barcode
Custom Function Name
For Barcode
=CONNECTCODE.ENCODE_CODE128B(PARAM1)
PARAM1 - Input Data
For Human Readable Text that appears below the barcode
=CONNECTCODE.ENCODE_CODE128B_HRT(PARAM1)
PARAM1 - Input Data
Fonts
CCodeCode128_S1
CCodeCode128_S2
CCodeCode128_S3 (ConnectCodeCode128_S3.ttf Default)
CCodeCode128_S4
CCodeCode128_S5
CCodeCode128_S6
CCodeCode128_S7
CCodeCode128B_HS3 (embedded Human Readable Text)
- Code 128C Barcode
Custom Function Name
For Barcode
=CONNECTCODE.ENCODE_CODE128C(PARAM1)
PARAM1 - Input Data
For Human Readable Text that appears below the barcode
=CONNECTCODE.ENCODE_CODE128C_HRT(PARAM1)
PARAM1 - Input Data
Fonts
CCodeCode128_S1
CCodeCode128_S2
CCodeCode128_S3 (ConnectCodeCode128_S3.ttf Default)
CCodeCode128_S4
CCodeCode128_S5
CCodeCode128_S6
CCodeCode128_S7
- Code 128 Auto Barcode
Custom Function Name
For Barcode
=CONNECTCODE.ENCODE_CODE128AUTO(PARAM1)
PARAM1 - Input Data
For Human Readable Text that appears below the barcode
=CONNECTCODE.ENCODE_CODE128AUTO_HRT(PARAM1)
PARAM1 - Input Data
Fonts
CCodeCode128_S1
CCodeCode128_S2
CCodeCode128_S3 (ConnectCodeCode128_S3.ttf Default)
CCodeCode128_S4
CCodeCode128_S5
CCodeCode128_S6
CCodeCode128_S7
- EAN13 Barcode
Custom Function Name
For Barcode
=CONNECTCODE.ENCODE_EAN13(PARAM1,PARAM2)
PARAM1 - Input Data
PARAM2 - Extended Style
For Human Readable Text that appears below the barcode
=CONNECTCODE.ENCODE_EAN13_HRT(PARAM1)
PARAM1 - Input Data
Fonts (Standard Style)
CCodeCodeUPCEAN_S1
CCodeCodeUPCEAN_S2
CCodeCodeUPCEAN_S3 (ConnectCodeUPCEAN_S3.ttf Default)
CCodeCodeUPCEAN_S4
CCodeCodeUPCEAN_S5
CCodeCodeUPCEAN_S6
CCodeCodeUPCEAN_S7
Fonts (Extended Style)
CCodeCodeUPCEAN_HRBS1
CCodeCodeUPCEAN_HRBS2
CCodeCodeUPCEAN_HRBS3 (ConnectCodeUPCEAN_HRBS3.ttf Default)
CCodeCodeUPCEAN_HRBS4
CCodeCodeUPCEAN_HRBS5
CCodeCodeUPCEAN_HRBS6
CCodeCodeUPCEAN_HRBS7
Fonts (Extended Style - Text on top of Barcode)
CCodeCodeUPCEAN_HRTS1
CCodeCodeUPCEAN_HRTS2
CCodeCodeUPCEAN_HRTS3
- EAN8 Barcode
Custom Function Name
For Barcode
=CONNECTCODE.ENCODE_EAN8(PARAM1)
PARAM1 - Input Data
Use the same Function for Extended Style
For Human Readable Text that appears below the barcode
=CONNECTCODE.ENCODE_EAN8_HRT(PARAM1)
PARAM1 - Input Data
Fonts (Standard Style)
CCodeCodeUPCEAN_S1
CCodeCodeUPCEAN_S2
CCodeCodeUPCEAN_S3 (ConnectCodeUPCEAN_S3.ttf Default)
CCodeCodeUPCEAN_S4
CCodeCodeUPCEAN_S5
CCodeCodeUPCEAN_S6
CCodeCodeUPCEAN_S7
Fonts (Extended Style)
CCodeCodeUPCEAN_HRBS1
CCodeCodeUPCEAN_HRBS2
CCodeCodeUPCEAN_HRBS3 (ConnectCodeUPCEAN_HRBS3.ttf Default)
CCodeCodeUPCEAN_HRBS4
CCodeCodeUPCEAN_HRBS5
CCodeCodeUPCEAN_HRBS6
CCodeCodeUPCEAN_HRBS7
Fonts (Extended Style - Text on top of Barcode)
CCodeCodeUPCEAN_HRTS1
CCodeCodeUPCEAN_HRTS2
CCodeCodeUPCEAN_HRTS3
- EXT2 Barcode
Custom Function Name
For Barcode
=CONNECTCODE.ENCODE_EXT2(PARAM1)
PARAM1 - Input Data
For Human Readable Text that appears below the barcode
=CONNECTCODE.ENCODE_EXT2_HRT(PARAM1)
PARAM1 - Input Data
Fonts (Standard Style)
CCodeCodeUPCEAN_S1
CCodeCodeUPCEAN_S2
CCodeCodeUPCEAN_S3 (ConnectCodeUPCEAN_S3.ttf Default)
CCodeCodeUPCEAN_S4
CCodeCodeUPCEAN_S5
CCodeCodeUPCEAN_S6
CCodeCodeUPCEAN_S7
Fonts (Extended Style)
CCodeCodeUPCEAN_HRBS1
CCodeCodeUPCEAN_HRBS2
CCodeCodeUPCEAN_HRBS3 (ConnectCodeUPCEAN_HRBS3.ttf Default)
CCodeCodeUPCEAN_HRBS4
CCodeCodeUPCEAN_HRBS5
CCodeCodeUPCEAN_HRBS6
CCodeCodeUPCEAN_HRBS7
Fonts (Extended Style - Text on top of Barcode)
CCodeCodeUPCEAN_HRTS1
CCodeCodeUPCEAN_HRTS2
CCodeCodeUPCEAN_HRTS3
- EXT5 Barcode
Custom Function Name
For Barcode
=CONNECTCODE.ENCODE_EXT5(PARAM1)
PARAM1 - Input Data
For Human Readable Text that appears below the barcode
=CONNECTCODE.ENCODE_EXT5_HRT(PARAM1)
PARAM1 - Input Data
Fonts (Standard Style)
CCodeCodeUPCEAN_S1
CCodeCodeUPCEAN_S2
CCodeCodeUPCEAN_S3 (ConnectCodeUPCEAN_S3.ttf Default)
CCodeCodeUPCEAN_S4
CCodeCodeUPCEAN_S5
CCodeCodeUPCEAN_S6
CCodeCodeUPCEAN_S7
Fonts (Extended Style)
CCodeCodeUPCEAN_HRBS1
CCodeCodeUPCEAN_HRBS2
CCodeCodeUPCEAN_HRBS3 (ConnectCodeUPCEAN_HRBS3.ttf Default)
CCodeCodeUPCEAN_HRBS4
CCodeCodeUPCEAN_HRBS5
CCodeCodeUPCEAN_HRBS6
CCodeCodeUPCEAN_HRBS7
Fonts (Extended Style - Text on top of Barcode)
CCodeCodeUPCEAN_HRTS1
CCodeCodeUPCEAN_HRTS2
CCodeCodeUPCEAN_HRTS3
- GS1 Databar 14 Barcode
Custom Function Name
For Barcode
=CONNECTCODE.ENCODE_GS1DATABAR14(PARAM1, PARAM2)
PARAM1 - Input Data
PARAM2 - 0 for stand alone. 1 for association with a 2D component.
For Human Readable Text that appears below the barcode
=CONNECTCODE.ENCODE_GS1DATABAR14_HRT(PARAM1, PARAM2)
PARAM1 - Input Data
PARAM2 - 0 for stand alone. 1 for association with a 2D component.
Fonts (Standard Style)
CCodeCodeGS1D_S1
CCodeCodeGS1D_S2
CCodeCodeGS1D_S3 (ConnectCodeCodeGS1D_S3.ttf Default)
CCodeCodeGS1D_S4
CCodeCodeGS1D_S5
CCodeCodeGS1D_S6
CCodeCodeGS1D_S7
CCodeCodeGS1DTR (GS1 Databar Truncated)
- I2of5 Barcode
Custom Function Name
For Barcode
=CONNECTCODE.ENCODE_I2OF5(PARAM1, PARAM2)
PARAM1 - Input Data
PARAM2 - 1 to generate check digit. 0 to turn off check digit.
For Human Readable Text that appears below the barcode
=CONNECTCODE.ENCODE_I2OF5_HRT(PARAM1, PARAM2)
PARAM1 - Input Data
PARAM2 - 1 to generate check digit. 0 to turn off check digit.
Fonts
CCodeCodeI2of5_S1
CCodeCodeI2of5_S2
CCodeCodeI2of5_S3 (ConnectCodeCodeI2of5_S3.ttf Default)
CCodeCodeI2of5_S4
CCodeCodeI2of5_S5
CCodeCodeI2of5_S6
CCodeCodeI2of5_S7
CCodeCodeI2of5_HS3 (embedded Human Readable Text)
- Industrial 2 of 5 Barcode
Custom Function Name
For Barcode
=CONNECTCODE.ENCODE_INDUSTRIAL2OF5(PARAM1, PARAM2)
PARAM1 - Input Data
PARAM2 - 1 to generate check digit. 0 to turn off check digit.
For Human Readable Text that appears below the barcode
=CONNECTCODE.ENCODE_INDUSTRIAL2OF5_HRT(PARAM1, PARAM2)
PARAM1 - Input Data
PARAM2 - 1 to generate check digit. 0 to turn off check digit.
Fonts
CCodeCodeIND2of5_S1
CCodeCodeIND2of5_S2
CCodeCodeIND2of5_S3 (ConnectCodeCodeIND2of5_S3.ttf Default)
CCodeCodeIND2of5_S4
CCodeCodeIND2of5_S5
CCodeCodeIND2of5_S6
CCodeCodeIND2of5_S7
- ITF14 Barcode
Custom Function Name
For Barcode
=CONNECTCODE.ENCODE_ITF14(PARAM1, PARAM2, PARAM3)
PARAM1 - Input Data
PARAM2 - 1 to generate check digit. 0 to turn off check digit.
PARAM3 - 0 for Top/Bottom Bearers Bar. 1 for Rectangle Bearers Bar.
For Human Readable Text that appears below the barcode
=CONNECTCODE.ENCODE_ITF14_HRT(PARAM1, PARAM2)
PARAM1 - Input Data
PARAM2 - 1 to generate check digit. 0 to turn off check digit.
Fonts
CCodeCodeITF_S1
CCodeCodeITF_S2
CCodeCodeITF_S3 (ConnectCodeCodeITF_S3.ttf Default)
CCodeCodeITF_S4
CCodeCodeITF_S5
CCodeCodeITF_S6
CCodeCodeITF_S7
- Modified Plessy Barcode
Custom Function Name
For Barcode
=CONNECTCODE.ENCODE_MODIFIEDPLESSY(PARAM1, PARAM2)
PARAM1 - Input Data
PARAM2 - 1 to generate check digit. 0 to turn off check digit.
For Human Readable Text that appears below the barcode
=CONNECTCODE.ENCODE_MODIFIEDPLESSY_HRT(PARAM1, PARAM2)
PARAM1 - Input Data
PARAM2 - 1 to generate check digit. 0 to turn off check digit.
Fonts
CCodeCodeMSI_S1
CCodeCodeMSI_S2
CCodeCodeMSI_S3 (ConnectCodeCodeMSI_S3.ttf Default)
CCodeCodeMSI_S4
CCodeCodeMSI_S5
CCodeCodeMSI_S6
CCodeCodeMSI_S7
- POSTNET Barcode
Custom Function Name
For Barcode
=CONNECTCODE.ENCODE_POSTNET(PARAM1)
PARAM1 - Input Data
For Human Readable Text that appears below the barcode
=CONNECTCODE.ENCODE_POSTNET_HRT(PARAM1)
PARAM1 - Input Data
Fonts
CCodeCodePostnet (ConnectCodePostnet.ttf Default)
- UCCEAN (GS1 128) Barcode
Custom Function Name
For Barcode
=CONNECTCODE.ENCODE_UCCEAN(PARAM1,PARAM2)
PARAM1 - Input Data
PARAM2 - 1 for strict GS1 Compliance. 0 for legacy support.
For Human Readable Text that appears below the barcode
=CONNECTCODE.ENCODE_UCCEAN_HRT(PARAM1,PARAM2)
PARAM1 - Input Data
PARAM2 - 1 for strict GS1 Compliance. 0 for legacy support.
Fonts
CCodeCode128_S1
CCodeCode128_S2
CCodeCode128_S3 (ConnectCodeCode128_S3.ttf Default)
CCodeCode128_S4
CCodeCode128_S5
CCodeCode128_S6
CCodeCode128_S7
- UPCA Barcode
Custom Function Name
For Barcode
=CONNECTCODE.ENCODE_UPCA(PARAM1,PARAM2)
PARAM1 - Input Data
PARAM2 - Extended Style
For Human Readable Text that appears below the barcode
=CONNECTCODE.ENCODE_UPCA_HRT(PARAM1,PARAM2)
PARAM1 - Input Data
PARAM2 - Extended Style
Fonts (Standard Style)
CCodeCodeUPCEAN_S1
CCodeCodeUPCEAN_S2
CCodeCodeUPCEAN_S3 (ConnectCodeUPCEAN_S3.ttf Default)
CCodeCodeUPCEAN_S4
CCodeCodeUPCEAN_S5
CCodeCodeUPCEAN_S6
CCodeCodeUPCEAN_S7
Fonts (Extended Style)
CCodeCodeUPCEAN_HRBS1
CCodeCodeUPCEAN_HRBS2
CCodeCodeUPCEAN_HRBS3 (ConnectCodeUPCEAN_HRBS3.ttf Default)
CCodeCodeUPCEAN_HRBS4
CCodeCodeUPCEAN_HRBS5
CCodeCodeUPCEAN_HRBS6
CCodeCodeUPCEAN_HRBS7
Fonts (Extended Style - Text on top of Barcode)
CCodeCodeUPCEAN_HRTS1
CCodeCodeUPCEAN_HRTS2
CCodeCodeUPCEAN_HRTS3
- UPCE Barcode
Custom Function Name
For Barcode
=CONNECTCODE.ENCODE_UPCE(PARAM1,PARAM2)
PARAM1 - Input Data
PARAM2 - Extended Style
For Human Readable Text that appears below the barcode
=CONNECTCODE.ENCODE_UPCE_HRT(PARAM1)
PARAM1 - Input Data
Fonts (Standard Style)
CCodeCodeUPCEAN_S1
CCodeCodeUPCEAN_S2
CCodeCodeUPCEAN_S3 (ConnectCodeUPCEAN_S3.ttf Default)
CCodeCodeUPCEAN_S4
CCodeCodeUPCEAN_S5
CCodeCodeUPCEAN_S6
CCodeCodeUPCEAN_S7
Fonts (Extended Style)
CCodeCodeUPCEAN_HRBS1
CCodeCodeUPCEAN_HRBS2
CCodeCodeUPCEAN_HRBS3 (ConnectCodeUPCEAN_HRBS3.ttf Default)
CCodeCodeUPCEAN_HRBS4
CCodeCodeUPCEAN_HRBS5
CCodeCodeUPCEAN_HRBS6
CCodeCodeUPCEAN_HRBS7
Fonts (Extended Style - Text on top of Barcode)
CCodeCodeUPCEAN_HRTS1
CCodeCodeUPCEAN_HRTS2
CCodeCodeUPCEAN_HRTS3