Pages: [1]   Go Down
Author Topic: arduino to excel  (Read 1074 times)
0 Members and 1 Guest are viewing this topic.
Offline Offline
Newbie
*
Karma: 0
Posts: 30
View Profile
 Bigger Bigger  Smaller Smaller  Reset Reset

Hi!

Im  searching for a simple way to get data from the Arduino into Excel for later processing of the data via Zigbee
 
any suggestion will be appreciate.
 Thanks!!
« Last Edit: January 16, 2014, 10:38:57 pm by heixin » Logged

Atlanta, USA
Offline Offline
Edison Member
*
Karma: 53
Posts: 1774
AKA: Ray Burne
View Profile
 Bigger Bigger  Smaller Smaller  Reset Reset

http://forum.arduino.cc/index.php?topic=135623.0

Yep... Too easy.

Ray

Edit: You can do keyboard HID with the Leonardo if you do not want to go the V-USB route.
« Last Edit: January 15, 2014, 09:51:16 pm by mrburnette » Logged

Dee Why NSW
Offline Offline
Edison Member
*
Karma: 47
Posts: 2177
View Profile
 Bigger Bigger  Smaller Smaller  Reset Reset

You surely can't get it any simpler than using PLX-DAQ.  This is an Excel macro that enables you to send your data direct to an open Excel sheet. It is simply a matter of properly formatting data that you would normally see on the serial monitor. Date/time stamping is done in Excel, no need for a clock on the Arduino. It can also do live graphs in Excel, and it is free!

Check here               http://forum.arduino.cc/index.php?topic=211274.0
« Last Edit: January 18, 2014, 08:41:06 pm by Nick_Pyner » Logged

Offline Offline
Newbie
*
Karma: 0
Posts: 3
View Profile
 Bigger Bigger  Smaller Smaller  Reset Reset

You could save the data locally (regular log on sd for example ) in a txt file and seperate the data with commas. Rename the file to .csv and just open with excel.
Logged

Seattle, WA USA
Offline Offline
Brattain Member
*****
Karma: 601
Posts: 48543
Seattle, WA USA
View Profile
 Bigger Bigger  Smaller Smaller  Reset Reset

Quote
Rename the file to .csv and just open with excel.
There is nothing magic about the txt extension, or the csv extension. The SD library doesn't care, so save a step and name it .csv to start with.
Logged

Pages: [1]   Go Up
Jump to: