Excel Barcode Generator Plug-In - Generate Data Matrix Images in MS Excel

Data Matrix Excel Barcode Generator Add-In

How to Generate Data Matrix Barcode in Excel 2019/2016/2013/2010/2007

Excellent Excel Data Matrix generator plug-in for Microsoft Excel users

Complete the installation only by clicking the setup file, without activation keys

Adjust Data Matrix barcode settings easily and flexibly in MS Excel spreadsheet

Easy to link the Data Matrix barcode images with the data in the Excel cells

Generated Data Matrix barcode images are compatible with latest industry criteria

Also suitable for other linear and 2D barcode generation in Microsoft Office Excel

How to Install MS Excel Data Matrix 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 Data Matrix barcode with Specified Image Width and Height

If you need generate Data Matrix 2d barcodes with required image width and height, and also need Data Matrix bar module (X) as max as possible.

How to Create GS1 Compatible Data Matrix Barcode

GS1 data can be encoded intoData Matrix. To create GS1 compatible Data Matrix barcodes, follow the steps below:

Barcode type should be Data Matrix
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 Data Matrix

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].

Data Matrix Barcode Property Settings

Set the Barcode Type property to DATAMATRIX

Set the Data property with the value to encode.
Type is string.

Set the Data mode property. Valid value is AUTO, ASCII, C40, Text, X12, EDIFACT BASE256.

ASCII: it is used to encode data that mainly contains ASCII characters (0-127).
C40: it is used to encode data that mainly contains numeric and upper case characters.
Text: it is used to encode data that mainly contains numeric and lower case characters.
Base256: it is used to encode 8 bit values.

Set the Format mode property for Data Matrix data mode format. Specifies the Data Matrix Format to use on that barcode.

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.

Provides High Quality Java Barcode, Java Barcode Library, Barcode Java, Java Barcode Generator, Java Barcode Generator Library and .NET Barcode Library, ASP.NET Web Barcode Library, C# Barcode Library, VB.NET Barcode Library, .NET Barcode Reader Library, Excel Barcode Software.