Generating Barcodes for App Testing

I wanted to share a helpful technique for generating QR codes in Excel, based off of Excel cell content, which helps me to simulate several product barcodes at once for app testing:


=IMAGE(“https://quickchart.io/qr?text=”&D2)

where D2 is the cell I’m referencing.

(Here is the API for that resource: QR Code API | QuickChart)

I’ve been using barcodes as well to simulate serial device outputs (e.g. Moutz EZ Torq III) to feed precise values to Tulip Player’s serial device connection, for testing high/low limits and significant digits and rounding logic.

1D barcodes are fine for short strings (but may require “extra” configuration of the scanner used to enable the full ASCII character set, including special characters and lowercase letters), but I’m finding for GS1 product barcodes, the 2D barcode QR code format is much more space-efficent and easier to capture with the scanner.

1 Like

Neat! Thanks for sharing Jim :slight_smile:

Work smarter, not harder, right?