ONE WAY IT CAN BE DONE IS WITH KEYBOARD WEDGE SOFTWARE.
With a keyboard wedge you can send temperature sensor data directly into spreadsheets, as if you were typing
A Keyboard Wedge acts in between a PC manual data entry application (e.g. Excel) and a PC connected device (e.g. a temperature sensor measurement module). The Keyboard Wedge converts serial data into simulated typing of the data. It works with a variety of applications, & is even possible to use to send live data to online storage, e.g. using Google Sheets and Docs! (All it takes is a Windows PC, and internet connection, and a Google account.)
KEYBOARD WEDGE SOFTWARE OPTIONS
A number of products are available, from a number of companies, with prices varying from a few dollars, to several hundred dollars. Some packages are Free! With each of these choices, there are both positive and negative points.
From the number of companies that offer Keyboard Wedge software, some publish packages that are flexible allowing connection to a variety of devices. In order for the keyboard wedge to work with that specific device, the protocol format of the data source, must be understood, & configured/entered into the application. Devices may have compatibility issues or difficulties working with some applications, so it is important to go over both the hardware manufacture and software publishers specifications and instructions carefully.
It is simpler to if possible to purchase the hardware and software from the same source, if a statement of compatibility is not available.
Robert Owen’s Keyboard Wedge is “A Keyboard Wedge converts sensor data into simulated typing”. The software is free, but it is also limited to use only with Robert Owen products. This case makes it simpler to use, much less to consider and set during the program initial setup for your application. Basically, you can start using it as soon as it’s installed. Learn more about Robert Owen’s Keyboard Wedge.
Another WAY IT CAN BE DONE IS WITH Excel Add-in SOFTWARE.
So, what about the Excel Add-in? Well, the Excel Add-in has the limit of working with Excel only, with the gain in simple setup and use. How to handle the device settings is already handled, and change in focus is no longer an issue.
“An Excel Add-in brings serial sensor data directly into Excel without the drawbacks of simulated typing”. Data is added into the spreadsheet via the spreadsheets VBA macro software. This is included with Robert Owen hardware, the software is free, but it is also limited to use only with the Robert Owen ROI-USB and similar products. Basically, you can start using it as soon as it’s installed.