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 Code 128 Using Excel Add-In
Excel Code 128 Generation Plug-in provides an easy way to integrate powerful barcode generation capabilities in Microsoft Excel within a few steps. Fully run within Microsoft Office Excel 2007 and 2010, all the generated Code 128 barcodes are pre-configured according to ISO / IEC 15417 (2nd edition 2007-06-01).
Code 128 Add-in for Excel supports Code 128 Sub set A, B, C to be used for data encryption in Excel. Besides, other data property options are available for customizing the Code 128 data encoding for Office Excel spreadsheets. Here is a user guide for Code 128 data encrypting in Excel. For other specific information on Code 128 barcode generation setting, please refer to the quick links:
Code 128 Data Related Properties

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

Excel Code 128 Barcode Add-in encodes:
  • Code128Auto: encodes all encodable characters of Code 128
  • Code128A: encodes all of the standard upper case alphanumeric characters and punctuation characters together with the control characters
  • Code128B: all of the standard upper case alphanumeric characters and punctuation characters together with the lower case alphabetic characters
  • Code128C: the set of 100 digit pairs from 00 to 99 inclusive, as well as three special characters

Code

Barcode Generator for Microsoft Excel gives full power to users to control Code 128 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 for Code 128 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

Human-readable Text

Barcode Generator for Microsoft Excel gives full power to users to decide that whether they want to display Code text or not under Code 128 symbol with Display Text option and specify it with Font option.
Customize Code 128 Barcode Data in Excel
Ensure you have installed those following programs before you start to encrypt your Code 128 valid character sets in Excel Workbook:
Customize Code 128 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 "Code 128";
  3. Input some data - "Code 128" in "Data";
  4. Click "Generate"; then a Code 128 barcode occurs in your Excel Workbook.
Encode Code 128 Barcode with Different Code Set
  1. Select the existed Code 128 barcode in Excel;
  2. Set "Barcode Type" to "Code 128C"
  3. Input some data - "641258" in "Data";
  4. Click "Update"; then a Code 128 barcode occurs in your Excel Workbook.
Encode Code 128 Barcode with "~" in Excel
  1. Select the existed Code 128 barcode in Excel;
  2. Go to "1D Barcode" and activate "Apply Tilde";
  3. Input some data - "~641258" in "Data";
  4. Click "Update"; then a Code 128 barcode occurs in your Excel Workbook.