BizCode Barcode Add-In for Microsoft Excel
The most professional and unique barcode solution for Microsoft Excel
Quick Overviews
  • Mature barcode plug-in
  • No Programming Skills
  • MS-Excel 2007/2010
  • Linear & 2D barcode support
  • Barcodes Freely Adjustable
How to Encode Data into PDF-417 Using Excel Add-In
MS-Excel PDF-417 Add-in is easy to create both a single PDF-417 barcode image and batch PDF-417 images in Microsoft Office Excel Workbook 2007 and Microsoft Office Excel Workbook 2010 fast, reliable and in professional quality. The installation PDF-417 Barcode Creator Add-in on Microsoft Office Excel Workbook within a few mouse clicks.
With this PDF-417 Plug-in, users may directly generate Standard PDF-417 barcode as well as Compact PDF-417/Truncated PDF-417 barcode from the latest PDF-417 barcode specification - ISO/IEC 15438 (2nd edition 2006-06-01). This passage provides a detailed PDF-417 data encoding guide below.
PDF-417 Data Related Properties

Symbology

Barcode Generator for Microsoft Excel provides Barcode Type option, when you want to encode PDF-417 barcodes in Excel.

Excel PDF-417 Barcode Generator encodes:
  • Standard ASCII characters 0-127 (default: ISO/IEC 646)
  • Extended ASCII characters 128-255 (default: ISO/IEC 8859-1)

Data Mode

Barcode Generator for Microsoft Excel provides Data Mode option, when you want to encode different types PDF-417 characters with different data modes:

5 PDF-417 data modes:
  • Auto: this component will determine the best data mode for you
  • Text: encodes all printable ASCII characters
  • Byte: encodes 8-bit values according to ISO/IEC 8859-1
  • Numeric: encodes 10 Arabic digits 0-9
  • Customer: encodes data according to the customer

Code

Barcode Generator for Microsoft Excel provides Data option, when you need to control PDF-417 barcode data length in Excel.

ProcessTilde

Barcode Generator for Microsoft Excel provides Apply Tilde option, when you need to encode some specific ASCII characters for PDF-417 with a tilde character "~".
  • 1-byte character: ~0dd/~1dd/~2dd (character value from 000 ~ 255); ASCII character '~' is presented by ~126
    Strings from "~256" to "~299" are unused
  • 2-byte character (Unicode): ~6ddddd (character value from 00000 ~ 65535)
    Strings from "~665536" to "~699999" are unused
  • Programming for reader initialization: ~rp.
    This should be located at the beginning of the encoding data, e.g. data = "~rpABCD1234".
  • ECI: ~7dddddd (valid value of dddddd from 000000 to 999999)

Error Correction Levels

Barcode Generator for Microsoft Excel provides Error Correction Level options, when you need different error correction levels, ranging from level 0 to level 8, for PDF-417 barcodes.
Customize PDF-417 Barcode Data in Excel
Ensure you have installed those following programs before you start to encrypt your PDF-417 valid character sets in Excel Workbook:
Encode PDF-417 Barcode Data in Excel
  • Create a new Excel Document and activate Barcode Add-In for Microsoft Excel;
  • Go to "Barcode Setting Panel" and choose "Barcode Type" to "PDF-417";
  • Input some data - "PDF-417" in "Data";
  • Click "Generate"; then a PDF-417 barcode occurs in your Excel Workbook.
Encode PDF-417 Barcode with Different Data Mode
  • Select the existed PDF-417 barcode in Excel;
  • Go to "2D Barcode" and choose "Data Mode" to "Byte";
  • Input some data - "*&%+-" in "Data";
  • Click "Update"; then a PDF-417 barcode occurs in your Excel Workbook.
Encode PDF-417 Barcode with "~" in Excel
  • Select the existed PDF-417 barcode in Excel;
  • Go to "2D Barcode" and activate "Apply Tilde";
  • Input some data - "~rpABCD1234" in "Data";
  • Click "Update"; then a PDF-417 barcode occurs in your Excel Workbook.
Encode PDF-417 Barcode with Different ECL in Excel
  • Select the existed PDF-417 barcode in Excel;
  • Go to "2D Barcode" and select "Error Correction Level" to "Level_2";
  • Click "Update"; then a PDF-417 barcode occurs in your Excel Workbook.