KA.Barcode for Excel
How to Resize EAN-13 Barcodes in MS Excel
How to print EAN 13 images and change barcode size in Excel using barcode generator addin
  • Easily create single in Microsoft Excel 2007/2010 with professional quality
  • Implementing dynamic barcodes, like EAN-8 .NET, VB.NET Code 39, Interleaved 2 of 5 VB.NET, Excel Codabar in your projects
  • Support generating EAN-13 barcodes and barcode lists or barcode tables in Excel
  • Printing EAN-13, EAN-13+2, EAN-13+5 with a few button clicks
  • Simple to adjust EAN-13 barcode size through various settings like bar width, image width, etc
  • Compatible with latest GS1 specification for valid EAN-13 output
  • Dynamic barcode components, such as Java barcode & .NET barcode, are provided
  • Advanced algorithm to automatically calculate, add check digit for EAN-13
  • Dynamically linking barcodes with the content of spreadsheet to update accordingly
This EAN-13 barcode addin software is a barcode functionality of KA.Barcode Addin for Microsoft Excel, which enables users to generate EAN-13, EAN-13+2, EAN-13+5 images in MS Excel 2007/2010 documents. With GS1 specification pre-configured, all barcodes generated are compatible with all printers and scanners.
EAN-13 Barcode Structure
EAN-13
EAN-13 barcode image size can be influenced by:
  • Bar width (X): narrow bar width of EAN-13; X min = 1 pixel
  • Bar height (Y): bar height of EAN-13; default value is 60 pixels
  • Image Width: EAN-13 barcode width
  • Image Height: EAN-13 barcode width
  • Left/Right Margin : quiet zone in EAN-13
EAN-13 Barcode Size Setting in Excel

Install KA.Barcode for Excel

  1. 1.
    Download KA.Barcode for Excel and unzip
  2. 2.
    Click KeepAutomation.Barcode.Excel.2007.Addin.msi to install
  3. 3.
    Open an Excel document. Click "install" in the pop-up "Microsoft Office Customization Installer" window
  4. 4.
    Switch to Add-In tab, click "Barcode" in the add-in, and a Barcode Setting panel pops up
  5. 5.
    Choose "EAN 13" in the "Barcode Type", input data, and click "OK"
  6. 6.
    Now an EAN 13 barcode image occurs in Excel
QR Code in ASP.NET Application. How to create QR Code images in ASP.NET web applications using free QR Code Barcode Generator Demo. ....
All four sides. QR Code Size Setting in with VB.NET Class. Install KA.Barcode Generator for .NET Suite into Projects. 1. Download KA. ....
Royalty-free, perpetual license with C# source code ....
With the user-friendly interface, users can adjust various dimensions of the generated QR Code image through VB.NET programming. ....
more>

Generate EAN-13 with Fixed Bar Width and Height

KA.Barcode Addin For Microsoft Excel allows users to easily set EAN-13 barcode width & height. Default value is 1 pixel for bar width and 60 pixels for bar height.
  1. 1.
    Set the value "Bar width (X)" to "2" and "Bar Height (Y)" to "60" in the property panel
  2. 2.
    Click "OK", then an EAN-13 barcode image occurs in the Excel spreadsheet

Adjust EAN-13 Supplement Bar Space and Bar Height

If users want to encode more information into a EAN-13 barcode like price, date, etc, you can simply refer to an EAN-13 with a two-digit or five-digit addon symbol. To control the size, you can adjust the space & bar height of the addon symbol.
  1. 1.
    Select "EAN 13+2" for the barcode type
  2. 2.
    Input 7 numeric digits in the "data" and 2 digits in the "Supplement data"
  3. 3.
    Set "Supplement bar height" to 0.8 and "Supplement bar space" to 15 pixels
  4. 4.
    Click "Generate" and an EAN-13+2 image is output

Print an EAN-13 with Fixed Image Width & Height

When space is the concern, users might want to create an EAN-13 barcode image with a fixed size. This is easily achieved by setting "Image width" and "Image height". Here is the sample procedure.
  1. 1.
    Set "Image width" to 150 pixels and "Image height" to 70 pixels
  2. 2.
    Click "OK" and a target EAN-13 with fixed size is generated