Hello,
In my Arduino project, I have a couple of strings. Is it possible to send these strings into an excel file in a couple of collums and rows? How do I do this? In Arduino and in Excel?
Maxim
Hello,
In my Arduino project, I have a couple of strings. Is it possible to send these strings into an excel file in a couple of collums and rows? How do I do this? In Arduino and in Excel?
Maxim
Easily.
Download putty.
Save data incoming from COM port the arduino is connected to as a .csv
.csv is COMMA SEPARATED VALUES.
So something like "10,dave,bob,1.7282 \n" on the Serial monitor in Putty will add a line to the excel file (.csv)
If you have a Windows PC and an older version of Excel (2003 works), use PLXDAQ to store data or plot within an open spreadsheet. Works great!
... or, if you have an Arduino Leonardo or Arduino Micro - they are recognisable as a keyboard - it is possible to write directly to an open spreadsheet. Pretty easy. ![]()
Johnny010:
Easily.Download putty.
Save data incoming from COM port the arduino is connected to as a .csv
.csv is COMMA SEPARATED VALUES.
So something like "10,dave,bob,1.7282 \n" on the Serial monitor in Putty will add a line to the excel file (.csv)
Thanks for the quick response.
I downloaded Putty, but what do I do next? When I open the putty.exe file, there opens a screen but I have no idea what to do next.
uxomm:
... or, if you have an Arduino Leonardo or Arduino Micro - they are recognisable as a keyboard - it is possible to write directly to an open spreadsheet. Pretty easy.
If you can maybe you can show us how to input temp sensor data and time into Excel using the EEPROM lib.h as a buffer using the Micro or Leonardo and the DS3231 real time clock.
http://forum.arduino.cc/index.php?topic=437398.0
Serial.print is about all the code you need. I don't know why you would bother playing at being a keyboard - or using an eeprom.