Pages: [1]   Go Down
Author Topic: can arduino be linked to microsoft excell  (Read 730 times)
0 Members and 1 Guest are viewing this topic.
0
Offline Offline
Newbie
*
Karma: 0
Posts: 15
Arduino rocks
View Profile
 Bigger Bigger  Smaller Smaller  Reset Reset

I was wondering if a arduino board could some how take some data coming in and transport it to excel, basically i have some accelaromitors hooked up to the board and was wondering if i can get that data ploted in to a spreadsheet? thanks for and help
Logged

Norway@Oslo
Offline Offline
Edison Member
*
Karma: 13
Posts: 2033
loveArduino(true);
View Profile
WWW
 Bigger Bigger  Smaller Smaller  Reset Reset

http://www.mikmo.dk/gobetwino.html

Not tested it myself but I think it works :]
Logged

SF Bay Area
Offline Offline
Full Member
***
Karma: 1
Posts: 182
Arduino rocks
View Profile
 Bigger Bigger  Smaller Smaller  Reset Reset

Someone has done that with graphing in real-time and also saving the values to a delimited text file so you can load it up in Excel.

http://www.arduino.cc/cgi-bin/yabb2/YaBB.pl?num=1246274143

I'm working on a version myself that will do something similar but also be able to configure it by editing text config files, and recording to a binary file for some external signal viewing programs.
Logged

Manchester (England England)
Offline Offline
Brattain Member
*****
Karma: 636
Posts: 34574
Solder is electric glue
View Profile
WWW
 Bigger Bigger  Smaller Smaller  Reset Reset

If you use processing you can save a file with a .cvs extension to the file name. This will open excell when you double click it.
Note you need some application at the PC end to gather data from the serial port and dump it to a file.
Logged

North Yorkshire, UK
Offline Offline
Faraday Member
**
Karma: 104
Posts: 5531
View Profile
 Bigger Bigger  Smaller Smaller  Reset Reset

You could log the data to an SD card as a file and then import it into Excel afterwards.

Depends on the application. Do you want it permenantly attached to a computer?

Mowcius
Logged

0
Offline Offline
Newbie
*
Karma: 0
Posts: 27
Arduino rocks
View Profile
 Bigger Bigger  Smaller Smaller  Reset Reset

If you just need the data once, or a few times (calibration maybe) wouldn't you just send it via serial and copy it from arduinos serial monitor?

If you need it as an ongoing application you might look into VBA-Scripting inside Excel. That should allow you to access the serial ports.
maybe something like this
http://dev.emcelettronica.com/serial-port-communication-excel-vba
Logged

Pages: [1]   Go Up
Jump to: