Forum Discussion

davbin1901's avatar
davbin1901
Copper Contributor
Jun 15, 2022

Data Matrix Barcodes for Excel

Does any have a technique to create DataMatix Barcode in Excel?

excel
  • mtarler's avatar
    mtarler
    Silver Contributor
    Jun 15, 2022

    davbin1901  I'm not sure what you are hoping for here but I don't know of a way to import an image into a cell for example but I did create a concept template to create a UDI for a product (using HIBC format) and then a macro that would download the QR code from the web and even copy to another sheet where I had product labels (i.e. make it easy to print labels with a UDI on it).  I have attached this concept template that maybe you could use as an idea how to do what you need.

    • Sean_M2015's avatar
      Sean_M2015
      Copper Contributor
      Dec 05, 2023

      mtarler Did you ever find a solution. I too am in need to take a cell with data in it and generate a DataMatrix barcode if you will. 

      • mtarler's avatar
        mtarler
        Silver Contributor
        Dec 06, 2023
        In the above is an example using a macro (with help from a website) to create a QRcode. Maybe there is a similar site to generate a DataMatrix barcode if it must be specifically DataMatrix instead of QRcode. In addition to the macro based solution above (which insert the image onto the sheet), excel has since added the new command IMAGE to insert an image INTO a cell so you could use something like:
        =IMAGE("https://api.qrserver.com/v1/create-qr-code/?data="& A1 &"&margin=1")
        to have that website generate a QR code based on cell A1 and then insert it into that cell.

Resources