Our Customers
Contact Us Email: support@barcodelib.com
Home > Barcode Excel Add-In > MS Excel Barcode Creating > How to Generate EAN 128 / GS1-128 Barcode in Excel
Download Barcode for Excel Trial

EAN 128 / GS1-128 Barcode Add-In for Excel

How to Link Cells with EAN 128 / GS1-128 Barcode in Excel
  • Mature EAN 128 / GS1-128 barcode generator with full support for Excel 2007 and 2010
  • Easy to generate & create EAN 128 barcode in selected cells, rows and columns of Excel
  • Able to convert entire rows or columns of data into EAN 128 barcode in Excel quickly
  • Compatible with other linear barcode generation in Excel, such as Code 128 and Code 39
  • Available for major 2D barcode generation in Excel, like QR Code, Data Matrix & PDF 417
  • Provide flexible perpetual license, including single-user & multi-user licenses
Installing Excel EAN 128 Barcode Generator Add-In
Integration with Office Excel
  • Download and unzip the evaluation package.
  • Close all Excel spreadsheets.
  • Run the "BarcodeLib.Barcode.Excel.{NNNN}.Addin.Setup.exe" to install. Note: {NNNN} is your Microsoft Office Excel verison, such as 2019, 2016, 2013.
How to Insert a EAN-128 barcode with Specified Image Width and Height
If you need generate EAN-128 barcodes with required image width and height, and also need EAN-128 bar module (X, Y) as max as possible.

  • Check property "Auto resize"
  • Set property "Image Width", "Image Height"
GS1-128/UCC/EAN-128 Barcode Property Settings
  1. Set the Barcode Type property to GS1 128.
  2. Set the Data property with the value to encode.
    Type is string.
    • Valid Data Scope:
      • all 128 characters of ASCII
    • Sample: "(21)2345777(21)12345678"
    • About AI (Application Identifiers)
      In Barcode Library, you can use (dddd) format to encode AI code.
      For example, to encode AI code 21 with value d12345777,and AI code 21 with value 12345678, you should set Data = "(21)d12345777(21)12345678".


  3. Check the Apply Tilde (~) property,, if you want use the tilde character "~" to specify special characters in the input data.
    • ~1: is used to represent the FNC1 code.
    • ~2: is used to represent the Structured Append and must be followed by a 3-digit number between 1 and 255.
    • ~3: is used only at the very beginning of the symbol for the reader programming purpose.
    • ~5: is used only at the very beginning of the symbol, the header [)> + ASCII 30 + ASCII 05 + ASCII 29 will be transmitted by the barcode reader before the data in the message and the trailer ASCII 30 + ASCII 4 will be transmitted afterwards.
    • ~6: is used only at the very beginning of the symbol, the header [)> + ASCII 30 + ASCII 06 + ASCII 29 will be transmitted by the barcode reader before the data in the message and the trailer ASCII 30 + ASCII 4 will be transmitted afterwards.
    • ~7NNNNNN: is used to specify the Extended Channel and NNNNNN is a value between 000000 and 999999.
    • ~dNNN: is used to represent the ASCII character with the value of NNN.
  4. Add checksum char property is not applied.


  5. Barcode Size Settings.
    • Set property Unit of Measure (Unit of Measure) for properties Bar Width, Bar Height, Margins.
      Valid values are Pixel, CM, Inch.
    • Set the Image Width and Image Height properties.
      Both types are float.
    • Set the Bar width (X) (for bar cell width) and Bar height (Y) (for bar cell height) properties.
      Both types are float.
    • Set the Left Margin, Right Margin, Top Margin and Bottom Margin properties.
      Types are all float.
    • If the Auto Resize property is chacked, the generated barcode image width and height will be the same as property "Image width", and "Image hight", and it will generate the maximum Bar Width and Bar Hight.
    • Set the DPI property (Value is expressed in DPI - Dots per inch).
      Type is int.
  6. Setting up Barcode data text style in barcode image (Tab: 1D Barcode).
    • Set the Display barcode data properties. If Display barcode data is checked, barcode data will be displayed with the barcode.
    • Set the Font property. The font used to display text in barcode image.
  7. Set Rotate property.
    If you want to rotate barcode image, valid values are : 0, 90, 180, 270
All Supported Linear & 2D Barcode Types in Excel 2019/2016/2013/2010/2007
You can also generate other linear barcodes in Excel spreadsheet as well.





Provides High Quality Java Barcode, Java Barcode Library, Barcode Java, Java Barcode Generator, Java Barcode Generator Library and .NET Barcode Library, ASP.NET Web Barcode Library, C# Barcode Library, VB.NET Barcode Library, .NET Barcode Reader Library, Excel Barcode Software.