Our Customers
|
MS Excel Barcode Generator Add-In for QR Code
How to Generate Dynamic QR Code Barcode in MS Office Excel 2019/2016
- 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
How to Install MS Excel QR Code Barcode Generator
Integration with Office Excel
- Close all Excel spreadsheets.
- Run the "BarcodeLib.Barcode.Excel.{NNNN}.Addin.Setup.exe" to install. Note: {NNNN} is your Microsoft Office Excel verison, such as 2019, 2016, 2013.
How to Insert a QR Code barcode with Specified Image Width and Height
If you need generate QR Code 2d barcodes with required image width and height, and also need QR Code bar module (X) as max as possible.
- Check property "Auto resize"
- Set property "Image Width", "Image Height"
How to Create GS1 Compatible QR Code Barcode
GS1 data can be encoded into QR Code.
To create GS1 compatible QR Code barcodes, follow the steps below:
- Barcode type should be QR Code
- Under tab "2D Barcode" in property panel, check property "GS1 Compatible Barcode"
- In barcode "Data" property, around AI code with "()", and followed by AI data, such as "(02)225(03)33344". Here "02", "03" are the AI code, "225", "33344" is the AI data.
How to Encode Non-printable Chars in QR Code
To encode non-printable chars (such as char 'TAB'), follow the steps:
- Check property "Apply Tilde (~)"
- Use 3-digits '~ddd' for non-printable chars. For example, ASCII char [GS] is non-printable, and its decimal value is 29. In barcode data, you need use ~029 for char [GS].
QR Code Barcode Property Settings
- Set the Barcode Type property to QRCODE
- Set the Data property with the value to encode. Type is string.
- 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.
- Set the Version property. Default is V1.
- Set the Error correction level property. QRCode Error Correction Level. Default is L.
- Check the GS1 Compatible Barcode property, if you need generate GS1 barcodes.
- 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.
- 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.
All Supported Linear & 2D Barcode Types in Excel 2019/2016/2013/2010/2007
You can also generate other linear barcodes in Excel spreadsheet as well.
- It is also available for 2d barcode types as follows:
|