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

Microsoft Excel PDF-417 Barcode Add-In

How to Insert PDF 417 Barcode Image in Excel Automatically
  • Simple to draw PDF-417 barcodes in Microsoft Office Excel document
  • Great barcode add-in which simplifies generation of multiple PDF-417 barcodes in Excel
  • Compatible with the latest PDF-417 ISO specification [ISO/IEC 15438 (Second edition 2006-06-01)]
  • Generate high quality PDF-417 images in your specified image width and height
  • Supporting PDF 417 for Excel 2019, 2016, 2013, 2010 and 2007
  • Professional Excel Barcode Generator add-in supporting all kinds of barcode settings
  • Achieve automatic barcode generation by linking cells with PDF-417 images in Excel
  • Support common industry linear and 2D barcode types, like QR Code and Code 39
Installing Excel PDF-417 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 PDF-417 barcode with Specified Image Width and Height
If you need generate PDF-417 barcodes with required image width and height, and also need PDF-417 bar module (X, Y) as max as possible.

  • Check property "Auto resize"
  • Set property "Image Width", "Image Height"
PDF-417 Barcode Property Settings
  1. Set the Barcode Type property to PDF417
  2. Set the Data property with the value to encode. Type is string.
  3. Set the Data mode property. Default is Auto that supports all the following encoding modes.
    • AUTO
    • BYTE: It allows encoding all 256 possible 8-bit byte values. This includes all ASCII characters value from 0 to 127 inclusive and provides for international character set support.
    • TEXT: It allows encoding all printable ASCII characters, i.e. values from 32 to 126 inclusive in accordance with ISO/IEC 646, as well as selected control characters such as TAB (horizontal tab ASCII 9), LF (NL line feed, new line ASCII 10) and CR (carriage return ASCII 13).
    • NUMERIC: It allows encoding numeric data.
  4. Set the Error correction level property. PDF417 Error Correction Level.
  5. Check the Truncated PDF-417 property. Truncated (Compact) PDF417 barcode is area efficient.
    Truncated PDF417 may be used where space considerations are a primary concern and symbol damage is unlikely.
  6. 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.
  7. Barcode Size Settings:
    • Set property Unit of Measure (Unit of Measure) for properties BarWidth, BarHeight, LeftMargin and TopMargin.
      Valid values are Pixel, CM, Inch.
    • Set the ImageWidth and ImageHeight properties.
      Both types are float.
    • Set the BarWidth (for bar cell width). Type is float, and default is 2.
    • Set the BarHight properties. Type is float.
    • Set the Rows properties. The number of data rows in the PDF-417 barcode.
      Type is int.
    • Set the Columns properties. The number of data columns in the PDF-417 barcode.
      Type is int.
    • Set the LeftMargin, RightMargin, TopMargin and BottomMargin properties.
      Types are all float. Default are 0.
    • 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.
  8. 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.