MS Excel Barcode Generator Add-In for QR Code

• Generate one or more QR Code barcodes in Excel with few easy steps
• Able to link cells with QR Code barcode images on Excel spreadsheet
• Easy to adjust QR Code settings like error correction levels and symbol versions
• Generated QR Code 2D barcode images are compatible with all printers
• Capable of generating popular linear barcodes in Excel like Code 39, EAN-13
• Support other major 2D barcode types, including PDF 417 and Data Matrix

1. Set the Barcode Type property to QRCODE
2. Set the Data property with the value to encode. Type is string.
3. Set the Data mode property. Default is QRCodeEncoding.Auto.
• AUTO: It allows encoding all 256 possible 8-bit byte values. This includes all ASCII characters value from 0 to 127 inclusive and provides for international character set support
• AlphaNumeric: It allows encoding alphanumeric data (digits 0 - 9; upper case letters A -Z; nine other characters: space, $ % * + - . / : ).
• Byte: It allows encoding byte data (default: ISO/IEC 8859-1).
• Numeric: It allows encoding numeric data (digits 0 - 9).
• Kanji: It allows encoding Kanji characters.
4. Set the Version property. Default is V1.
5. Set the Error correction level property. QRCode Error Correction Level. Default is L.
• L
• M
• Q
• H
6. Check the GS1 Compatible Barcode property, if you need generate GS1 barcodes.
7. Check the Apply Tilde (~) property,, if you want use the tilde character "~" to specify special characters in the input data.
• ~1: is used to represent the FNC1 code.
• ~2: is used to represent the Structured Append and must be followed by a 3-digit number between 1 and 255.
• ~3: is used only at the very beginning of the symbol for the reader programming purpose.
• ~5: is used only at the very beginning of the symbol, the header [)> + ASCII 30 + ASCII 05 + ASCII 29 will be transmitted by the barcode reader before the data in the message and the trailer ASCII 30 + ASCII 4 will be transmitted afterwards.
• ~6: is used only at the very beginning of the symbol, the header [)> + ASCII 30 + ASCII 06 + ASCII 29 will be transmitted by the barcode reader before the data in the message and the trailer ASCII 30 + ASCII 4 will be transmitted afterwards.
• ~7NNNNNN: is used to specify the Extended Channel and NNNNNN is a value between 000000 and 999999.
• ~dNNN: is used to represent the ASCII character with the value of NNN.
8. Barcode Size Settings.
• Set property Unit of Measure (Unit of Measure) for properties Bar Width, Margins.
  Valid values are Pixel, CM, Inch.
• Set the Image Width and Image Height properties.
  Both types are float.
• Set the Bar width (X) (for bar cell width) property.
  The type is float.
• Set the Left Margin, Right Margin, Top Margin and Bottom Margin properties.
  Types are all float.
• If the Auto Resize property is chacked, the generated barcode image width and height will be the same as property "Image width", and "Image hight", and it will generate the maximum Bar Width and Bar Hight.
• Set the DPI property (Value is expressed in DPI - Dots per inch).
  Type is int.