Go Down

Topic: can arduino be linked to microsoft excell (Read 785 times) previous topic - next topic

rockdog70

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

AlphaBeta

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

Not tested it myself but I think it works :]

oscarcar

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.

Grumpy_Mike

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.

mowcius

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

sevensuns

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

Go Up