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 Data Matrix Using Excel Add-In
Excel Data Matrix Creator Add-in is an office barcode generating component that creates and adds high-quality Data Matrix barcodes in Microsoft Excel 2007 and Excel 2010. ISO standards of Data Matrix - ISO / IEC 16022 (2nd edition 2006-09-15) has been configured in the barcodes, which helps untrained users easily create Data Matrix into Excel.
Variable and adjustable barcode data, image and sizing support helps you get ideal Data Matrix with multiple data types in Excel Workbook. Here is a detailed Data Matrix barcode setting guide for you. For details on Data Matrix barcode generation setting about Data Matrix size and image, please refer to the quick links:
Data Matrix Data Related Properties

Symbology

Barcode Generator for Microsoft Excel gives full power to users to determine that which data type they want to encode into Data Matrix barcode with Barcode Type option.

Excel Data Matrix Barcode Add-in 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 gives full power to users to determine that which data mode to be used for encode Data Matrix valid character sets with different data mode.

8 Data Matrix data modes:
  • Auto: this component will determine the best data mode for you
  • ASCII: encodes standard ASCII characters 0-127
  • C40: mainly encodes upper-case alphabetic, numeric and other characters to be encoded by the use of shift characters in conjunction withthe data character.
  • Text: encodes encode normal printed text,
  • X12: encodes the standard ANSI X12 electronic data interchange characters
  • Edifact: encodes 63 ASCII values (values from 32 to 94) plus an Unlatch character (binary 011111) to return to ASCII encodation.
  • Base256: encodes any 8-bit byte data, including extended channel interpretations and binary data
  • Customer: encodes data according to the customer

Code

Barcode Generator for Microsoft Excel gives full power to users to control Data Matrix barcode data length with Data option.

ProcessTilde

Barcode Generator for Microsoft Excel gives full power to users to decide that whether to encode special ASCII characters or GS1 Application Identifiers for Data Matrix using a tilde character "~" with Apply Tilde option.
  • 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
  • for GS1 AI Code:
  • ECI: ~7dddddd (valid value of dddddd from 000000 to 999999)
  • ~rp: Reader Programming (for ASCII mode and Auto mode only)
    This should be located at the beginning of the encoding data, e.g. data = "~rpABCD1234".
  • ~m5: 05 Macro (for ASCII mode and Auto mode only)
    This should be located at the beginning of the encoding data, e.g. data = "~m5ABCD1234".
  • ~m6: 06 Macro (for ASCII mode and Auto mode only)
    This should be located at the beginning of the encoding data, e.g. data = "~m6ABCD1234".
Customize Data Matrix Barcode Data in Excel
Ensure you have installed those following programs before you start to encrypt your Data Matrix valid character sets in Excel Workbook:
Encode Data Matrix Barcode Data in Excel
  1. Create a new Excel Document and activate Barcode Add-In for Microsoft Excel;
  2. Go to "Barcode Setting Panel" and choose "Barcode Type" to "Data Matrix";
  3. Input some data - "Data Matrix" in "Data";
  4. Click "Generate"; then a Data Matrix barcode occurs in your Excel Workbook.
Encode Data Matrix Barcode with Different Data Mode
  1. Select the existed Data Matrix barcode in Excel;
  2. Go to "2D Barcode" and select "Data Mode" to "Base256";
  3. Input some data - "%&*" in "Data";
  4. Click "Update"; then a Data Matrix barcode occurs in your Excel Workbook.
Encode Data Matrix Barcode with "~" in Excel
  1. Select the existed Data Matrix barcode in Excel;
  2. Go to "2D Barcode" and activate "Apply Tilde";
  3. Input some data - "~ai2456Data Matrix" in "Data";
  4. Click "Update"; then a Data Matrix barcode occurs in your Excel Workbook.