Our Customers
Contact Us Email: support@barcodelib.com
Home > Barcode Excel Add-In > MS Excel Barcode Creating > EAN-8 Barcode Generator Used in Excel
Download Barcode for Excel Trial

EAN 8 Barcode Generator Plug-in for Excel 2019 and 2016

How to Convert Data in Excel to 1D EAN-8 Barcode Labels
  • Good Excel EAN-8 barcode generator add-in which can be used in inventory control
  • Generate high-quality EAN-8 barcode in Excel, without adding any barcode fonts
  • Easily and quickly convert your data in Excel spreadsheet to EAN-8 barcode
  • Able to link cells with corresponding EAN-8 barcodes in Microsoft Excel
  • Customize EAN-8 barcode image size by inputting corresponding numeric values
  • Generate & rotate EAN-8 barcode in Excel with four available orientations
Guidance to Install EAN-8 Generator Add-In to Excel
Integration with Office Excel
  • 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-8 barcode with Specified Image Width and Height
If you need generate EAN-8 barcodes with required image width and height, and also need EAN-8 bar module (X, Y) as max as possible.

  • Check property "Auto resize"
  • Set property "Image Width", "Image Height"
EAN-8 Barcode Property Settings
  1. Set the Barcode Type property to EAN 8 or EAN 8 +2 or EAN 8 +5.
  2. Set the Data property with the value to encode. Type is string.
    User should only provide 7 digits, and DO NOT include last digit checksum character.
    1. Valid Data Scope:
      • 0, 1, 2, 3, 4, 5, 6, 7, 8, 9
    2. Valid Data Format:
      7 digits. There are totally 8 digits in EAN-8 barcode, first 7 digits are barcode value, and last digit is the checksum digit, which is generated by barcode library automatically.
    3. Sample: Data = "1234567"
  3. Set the Supplement data property with the supplement value to encode. Type is string.
    Provide 2 digits for barcode type EAN 8 +2, and provide 5 digits for type EAN 8 +5.
    Sample for BarcodeType.EAN8_2: barcode.SData = "12".
    Sample for BarcodeType.EAN8_5: barcode.SData = "12345".

  4. Add checksum char property is not applied here. Barcode Library will always add a check character in the last digit (modulo 10).

  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.