Version 9.4 lets you generate barcodes from live data directly on your web page. Another new widget lets you create QR codes that can be easily scanned by mobile devices.
And we have included a new example for checking that your installation of the Excel add-in works as it should.
Excel is an enormously versatile tool, extensively used in logistics. In combination with SpreadsheetConverter, your skills in Excel can be leveraged both to the global web environment and to personal iPhone and Android devices.
With version 9.4, we take our first step into the world of supply chain automation. Users now can create waybills and other shipping documents directly from templates made with Excel. Important information from Excel can be scanned right off the screen of any mobile device.
What happened in June 1974? Well, Dolly Parton released the single version of I Will Always Love You, Elton John released the Caribou album, and the first UPC barcode was scanned off a packet of Wrigley’s chewing gum at the Marsh Supermarket in Troy, Ohio. Since then, barcodes have revolutionized many major industries, and every day help to automate billions of business transactions around the world.
Two new widgets in SpreadsheetConverter version 9.4 let you generate barcodes and QR codes directly in your web page, either from static content or calculated by formulas and live data in a web form.
Barcodes are one-dimensional, linear images containing information that typically identifies the object that carries the barcode. Most items in today’s shopping malls are marked with barcodes that are used to look up the price for each scanned item and add it to the total.
Barcodes are also used for tracking purposes. Many trackable object like vehicles, containers, pallets, bags and parcels carry a barcode that identifies the object and makes it easy to track it during transportation.
In your office, there may be barcodes mounted discreetly on the walls. If a passing guard scans these barcodes, it is easy to track the areas of the building that have been surveilled.
Barcodes can be scanned directly off the screen or printed on labels. In this first release, we support the following barcode formats:
QR codes are images with a two-dimensional matrix that is often scanned by or displayed in smartphones. If users see a QR code during a self-guided tour, they can scan it with their phone’s camera to get more information about a significant object, either by listening to a voice recording or by reading a web page.
Since QR codes are square, they fit the phone’s screen well both in portrait and landscape mode, which have made them popular as linking tools, like the link to one of our example calculators above (scan it with your phone now!). QR codes can also be used for marketing purposes and in discount coupons.
Of course, QR codes can be also used for identification purposes like any standard barcode, and were actually initially developed to track parts in vehicle manufacturing.
For QR codes, we initally support the following code formats:
There are many other common barcode formats, like Pharmacode, MSI, ITF, Code 39 and ISBN. For the QR code there is also the WiFi login, website login, various types of payments and several other formats. What are your particular requirements? Please let us know and maybe we can support them in a future version.
Are you interested in a Scan barcode widget that uses the phone’s camera to scan barcodes and enter the decoded contents into a form? Please let us know.
The barcode and QR code widgets are currently not supported in the ASP.Net flavor.
The Errors tab now alerts you with a red notification containing the number of messages during the most recent conversion.
If you get any error messages you don’t understand, we welcome you to contact our Help Desk. For your convenience, we have made it possible to report conversion errors and ask questions directly from the Errors tab in the task pane.
If you click the Help button, a form opens where you can enter your e-mail address and an error description. When you press Send the form is sent to our Help Desk.
When you submit the error report you can attach valuable debugging information depending on your choices in the Attachments section. Without some of this information we may be unable to recreate many errors.
There are many “Internet Security” products for safe browsing. Some of these products may incorrectly assume that SpreadsheetConverter contains malicious code. With version 9.4 there is additional support for Bitdefender, which does not permit e2o2.exe to run, even though this is a completely harmless program that has been used safely in thousands of installations since 2002. If you use Bitdefender, you need to turn off all switches including Safe Files before you press the Convert button on the SpreadsheetConverter menu in Excel.
There are no known security vulnerabilities in SpreadsheetConverter. Read more on the help page for Internet Security.
This update is free to all version 9 users – just download and install the latest version of the program. If you are using version 8 or earlier, you must first upgrade to the latest version.
If you need help, don’t hesitate to contact our Help Desk.
Did you miss the introduction of version 9?