Forum Discussion
davbin1901
Jun 15, 2022Copper Contributor
Data Matrix Barcodes for Excel
Does any have a technique to create DataMatix Barcode in Excel?
- mtarlerSilver Contributor
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_M2015Copper Contributor
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.
- mtarlerSilver ContributorIn 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.