How to scan a QR-code into an Excel spreadsheet in real-time with your computer’s webcam. Also, how to scan a regular barcode into an Excel spreadsheet in real-time with your computer’s webcam. |
Quickmark QR-code scanning software has a couple of important limitations: The keyboard output feature works with MS Excel but not Google spreadsheet (because it sends an [Enter] key after each scan instead of the [DownArrow] whic h is needed for Google Spreadsheet. Also, the Quickmark program’s keyboard output works only in (unusable) demo mode unless you upgrade to the "Advanced version" for $9.99.
************************************************************************************
UPDATE: HERE IS A PROGRAM THAT IS BETTER THAN QUICKMARK:
ZBarSpreadsheet is a FREE program that can also scan QR-codes from webcam to spreadsheet in real-time. ZBarSpreadsheet works with both Excel and Google Spreadsheet. You can read more about it at this link.
************************************************************************************
This article is written about QuickMark_PC version 3.8 downloaded on 3/9/2012. There are a few minor quirks to overcome before you can use it:
Configure the General settings before your first scan:
To capture the scanned data to a TEXT FILE and also automatically type the scan data into Excel or a another program:
Note: the data from any barcode or QR-code you scan will be also saved to the file and folder below:
C:\Program Files (x86)\SimpleAct\QuickMark\ScanHistory.txt
QR-code Excel Spreadsheet Setup:
To capture the scanned data to a TEXT FILE — but NOT automatically type the data into Excel or a another program:
After changing these settings, the data from any barcode or QR-code you scan will be saved to the file and folder below:
C:\Program Files (x86)\SimpleAct\QuickMark\ScanHistory.txt
March 10, 2012 at 3:14 am
I’ve shared this tool and data with our friends at http://www.facebook.com/QuickResponseCode. Please feel free to post any of your QRC related writings with there on that page.
Best regards,
Jeff Nix @ http://www.facebook.com/QuickResponseCode