I am researching some options to read output from the arduino into Excel. Some options I found to use are CoolTerm and MS DataStreamer. However, I need a software that will allow me to have the serial monitor and excel file open simultaneously because the user has to provide input to the serial monitor. Would either CoolTerm or MS DataStreamer allow me to do this? and if not are there any other suggestions that can do this?
HID keyboard.
The Leonardo and little bro did this as did V-USB implementations.
Ex: String numeric output with V-USB HID - Community / Exhibition / Gallery - Arduino Forum
Adafruit Trinket can do same.
sounds like you require two concurrent arduino serial ports 1. serial monitor 2. to save data to Excel file
what arduino are you using?
do you have a USB to serial dongle, e.g. a TTL-232R-5V for a 5v logic device such an Arduino Mega or a TTL-232R-3V3 for 3.3V logic device such as an Arduino Due, ESP32, etc
CoolTerm is a terminal program; it can save data to file. It also allows you to send text from your PC to the Arduino.
Im using an arduino uno r3. And no i dont have any of those
probably the simplest way is to use the log facility of a terminal emulator (e.g. I use TeraTerm and REalTerm
after programming the Arduino device
- close the serial monitor (if open)
- connect the terminal emulator ro the arduino USB COM port
- open a log file
as the Arduino program
- prints to Serial the output will appear on the terminal emulator display and be saved to the log file
- information entered on the terminal emulator keyboard will be transmitted to the arduino - be careful to have the correct end of line character(s)
when program run is complete close the log file
make sure that the serial print output is in a form suitable for input the Excel, e.g. comma seperated numbers, etc - otherwise you may need to edit the log file
This topic was automatically closed 180 days after the last reply. New replies are no longer allowed.