KA.Barcode for Excel
How to Resize PDF-417 Barcodes in MS Excel
How to generate, draw and print PDF-417 images and change barcode size in Excel
  • Full integration into Microsoft Office Excel 2007/2010
  • Easily generate PDF417 barcode in single cell of columns for multiple barcode generation
  • Excel Intelligent Mail, EAN 128 .NET, Excel ISBN, Excel PDF417 & Codabar Excel can be created as well
  • Supporting generating Compact PDF417 (Truncated PDF417) for better space efficiency
  • Flexible settings to adjust PDf417 image size like bar width & image width, height
  • Adjusting PDF417 row number and column number
  • PDF417 images generated are compatible with ISO/IEC PDF417 symbology specification
  • Easy to use for all users with no programming skills needed
  • Draw and export high-quality Word UPC-E, PDF417 .NET, C# EAN 128 barcodes as you wish
  • Powerful and light-weight barcode plugin for Excel with no third party tools needed
PDF417 barcode plugin software is a barcode funtionality of KA.Barcode Addin for Excel, which can effectively generate a single or multiple PDF417 images and other linear, two-dimensional barcode types in Microsoft Excel worksheets.
PDF-417 Barcode Structure
A PDF417 barcode size can be decided by the following factors:
  • Bar width (X) and Bar height (Y)
  • Image Width and Image Height
  • Truncated PDF417
  • Row and column count
  • Quiet Zones (margins on four sides)
PDF-417 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 "PDF417" in the "Barcode Type", input data, and click "OK"
  6. 6.
    Now a PDF417 barcode image occurs in Excel

Generating PDF417 with Defined Bar Width & Wide to Narrow Bar Ratio

If you want to generate a PDF417 with defined bar width and height, you only need to adjust X and wide to narrow bar ratio. Default value for bar width is 1 pixel, and wide to narrow bar ratio 2. Here is a demo.
  1. 1.
    Set the value "Bar width (X)" to "2" and "Wide to narrow bar ratio" to "2" in the property panel
  2. 2.
    Click "OK", then a Data Matrix barcode image with defined bar width and height occurs in the Excel spreadsheet

Creating PDF417 with Fixed Image Width & Height

In order to create a PDF417 with fixed barcode width & height, you can simply set a proper value to "Image width" and "Image height". Here is the procedure.
  1. 1.
    Set "Image width" to 150 pixels and "Image height" to 70 pixels
  2. 2.
    Click "OK" and a target PDF417 with fixed size is generated

Drawing PDF417 with Specified Row Number and Column Number

With KA.Barcode Addin for Microsoft Excel, users are also allowed to define PDF417 row number and column number. Default for row number is 3, valid from 3-90. Default for column number is 5, valid from 1-30.
  1. 1.
    Switch to "2D Barcode" tab and set "Row count" to 3, and "Column count" to 5
  2. 2.
    Click "OK" and a target PDF417 with fixed row & column number is generated

Making Truncated PDF417 Barcode

When space is concerned, this PDF417 barcode addin software allows users to generate a PDF417 truncated as is specified in barcode specification. Just tick "Truncated PDF417" to true.
  1. 1.
    In the "2D Barcode" tab, tick "Truncated PDF417" to select
  2. 2.
    Click "OK" and a truncated PDF417 is generated

Adjusting PDF417 Quiet Zones

The ISO/IEC PDf417 symbology specification requires a minimum 2X quiet zones, i.e. margins on all four sides of a PDF 417 barcode image. So if you set X dimension to 2, you should take the following procedures as well.
  1. 1.
    Set "Left margin", "Right margin", "Top margin" and "Bottom margin" to 4 pixels
  2. 2.
    Click "OK" and a PDF417 with 4 pixel sorrounding margins is generated