Easy to generate and insert barcode on Excel spreadsheet
Avapose.Barcode for Excel
  • Mature barcode generation add-in for MS-Excel 2007/2010
  • Support 20+ common linear and 2D barcodes creation
  • Provide freely adjustable barcode options
UPC-A Barcode Generation on Excel
  • Seamlessly integrated into Microsoft Office Excel 2007 and 2010
  • Mature and professional component for UPC-A creation on Excel
  • Provide detailed tutorial for users easier installation and implementation
  • Human-readable interpretation may be disabled for other applications
  • Flexible barcode size options are included in this add-in
  • Royalty-free with the purchase of Excel UPC-A Add-In developer license
  • Complete function including dynamic UPC-A generation
  • No requirement of programming skill or barcode knowledge
Excel UPC-A Add-In is designed to allow users of Microsoft Excel to easily integrate UPC-A barcode technology into Excel applications. Complete barcode generation functions are provided from various aspects like barcode size, graphic, supplement barcode, etc. Advanced bar-coding tasks, like dynamically linking barcodes with the content of your spreadsheet, are supported as well.
UPC-A Add-In for Excel - UPC-A Information
UPC-A is the most common linear symbology in the United States which is uniquely assigned to each trade item. UPC-A is a subset of EAN-13. In reality, an UPC-A bar code is an EAN-13 bar code with the first EAN-13 number system digit set to "0". This means that any hardware or software capable of reading EAN-13 is automatically capable of reading UPC-A.
UPC-A Valid Encoding Characters:
  • Numeric digits: 0 - 9
UPC-A is a 13-digit-length barcode including the last check character. In addition, 2 or 5 supplement data can be encoded as the supplement barcode.
UPC-A Add-In for Excel - UPC-A Generation

Requirements:

Before implementing UPC-A Add-In for Excel, you need to install:
  • Microsoft Office 2007 PIA
  • .NET Framework 3.5 SP1
  • Windows Installer 3.1
  • VSTO 3.0 Runtime SP1
  • Avapose.Barcode for Excel

Generate a Single UPC-A on Excel

  1. Open the target Excel spreadsheet and activate Excel Barcode Add-In by clicking "Create Barcode" under "Add-Ins" tab;

  2. Select a certain cell of Excel to insert the UPC-A to be generated;
  3. Choose barcode type with three choices in the "barcode type" pull-down list, like "UPC-A+2";
  4. Input data with your need like "123456123456" in the "data" box and the supplement data like "00" in "Supplement data";
  5. Adjust the parameters that are required like "Left margin", "Right margin", "Display barcode data", "Rotate", etc;
  6. Click "Generate" to output the target UPC-A on the chosen cell of Excel.
If some customization is required for the generated UPC-A, please select it and adjust the related parameters in the setting panel. After that, click "Update". Alternatively, you can delete the barcode by clicking "Delete" button and generate a new one.

Create a List of UPC-A on Excel

  1. Open the Excel Barcode Add-In;
  2. Select a list of cells, choose "UPC-A" in the "barcode type" pull-down list and input the data to be encoded as well as supplement data if possible;
  3. Customize the parameters that you need like "Supplement bar height" "Supplement bar space", "Bar height", "Font", "Rotate", etc;
  4. Click "Generate" and a list of UPC-A barcodes float on Excel as required.

Link a UPC-A to a Certain Cell on Excel

  1. Select the generated UPC-A and click "link to cell";
  2. Select the target cell with data;
  3. Click "Update" where "link to cell" button is located;
  4. The generated UPC-A can automatically update with the data of the linked cell.
If the data of the linked cell changes, you can click "update link to cell" to automatically update the barcode image.
Related UPC-A Products & Information
The following UPC-A products and UPC-A barcode creating information links relate to this product that may be of interest to you:
Testimonial for Avapose.Barcode for Excel
We bought your product Barcode Add-In for Excel a few weeks ago, and it works pretty well!
Carios Louis, Eureka Software Ltd, UK