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
  • Barcode for Excel includes creating QR Code in Excel, Code 128 in Excel, Code 39 in Excel, Data Matrix in Excel, PDF-417 in Excel.
  • Mature and professional component for QR Code creation on Excel
  • Create QR Code straightforward on Excel spreadsheet with simple clicks
  • No extra hardware extensions are required for QR Code printing with printers
  • Version support allows changes to QR Code size excluding other sizing options
  • All QR Code barcodes are pre-configured according to industry standards
  • Complete function including dynamic QR Code generation
  • No requirement of programming skill or barcode knowledge
  • Royalty-free with the purchase of Excel QR Code Add-In developer license
QR Code Add-In for Excel is a mature and robust QR Code generation function designed for Microsoft Excel spreadsheet. With this add-in, users can straightforward generate QR Code barcode on Excel with simple clicks. Additionally, dynamic barcode generation capability is supported, which can let a generated QR Code image automatically update with the content of the linked cell on Excel.
QR Code Add-In for Excel - QR Code Information
QR Code, abbreviated from Quick Response Code, is a very efficient, two-dimensional (2D) barcode symbology which was developed for the automotive industry and now is commonly used with smart-phone devices because of its fast readability and large storage capacity. Characters, numbers, text and actual bytes of data may be encoded, including Unicode characters and images.
QR Code Valid Encoding Characters:
  • Numeric data: 0 - 9
  • Alphanumeric data: 0 - 9; A - Z; space, $ % * + - . / :
  • Byte data (default: ISO/IEC 8859-1)
  • Kanji characters
QR Code Add-In for Excel - QR Code Generation

Implementation Requirements:

Before implementing QR Code Add-In for Excel, please 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 QR Code on Excel

  1. Start 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 and choose "QR CODE" in the "barcode type" pull-down list;
  3. Enter barcode data in the "data" box, like "Excel QR Code";
  4. Adjust the parameters that are required like "Data mode", "Version", "Error correction level", "Rotate", etc;
  5. Click "Generate" to output the target QR Code on the chosen cell of Excel.
If some customization is required for the generated QR Code, 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 QR Code on Excel

  1. Open the Excel Barcode Add-In;
  2. Select a list of cells, choose "QR CODE" in the "barcode type" pull-down list and input the data to be encoded;
  3. Customize the parameters that you need like "Data mode", "Version", "Error correction level", "Rotate", etc;
  4. Click "Generate" and a list of QR Code barcodes will float on Excel as required.

Link a QR Code to a Certain Cell on Excel

  1. Select the generated QR Code 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 QR Code is dynamically linked to the target cell.
If the data of the linked cell changes, you can click "update link to cell" to automatically update the barcode image.
Related QR Code Products & Information
The following QR Code products and QR Code 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