Barcode for Excel User Guide
Excel Data Matrix
Our Customers
Contact Us Email: support@barcodelib.com
Home > Barcode Excel Add-In > MS Excel Barcode Creating > Generate Data Matrix Barcode in Excel Using an Add-In
Download Barcode for Excel Trial

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.

  • Check property "Auto resize"
  • Set property "Image Width", "Image Height"
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
  1. Set the Barcode Type property to DATAMATRIX
  2. Set the Data property with the value to encode.
    Type is string.
    1. Valid Data Scope:
      • All 128 characters of ASCII
    2. Sample: "123456789012"
  3. 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.
  4. Set the Format mode property for Data Matrix data mode format. Specifies the Data Matrix Format to use on that barcode.
  5. Check the GS1 Compatible Barcode property, if you need generate GS1 barcodes.
  6. 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.
  7. 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.