Arduino Forum

Using Arduino => Interfacing w/ Software on the Computer => Topic started by: Fixador on Feb 10, 2011, 12:48 am

Title: Serial Comms to MS Excel
Post by: Fixador on Feb 10, 2011, 12:48 am
I am putting this link in - as a reference for anyone who wants to get the arduino to send data to an Excel spreadsheet.

http://dev.emcelettronica.com/serial-port-communication-excel-vba (http://dev.emcelettronica.com/serial-port-communication-excel-vba)   

please pay particular attention to the one line of the code that needs to be modified if your serial port number is greater then  COM4 - i didnt, and struggled !

I have recently started using this myself to get the outputs from 4 thermocouples - upto 1100 degC  ( via a Ryan j Mclaughlin arduino shield ) - got great graphs now !
Title: Re: Serial Comms to MS Excel
Post by: Jujo on Feb 11, 2011, 09:31 am
There is also a ready-to-use free solution. It is based on PLX-DAQ software from Parallax:
http://www.parallax.com/tabid/393/Default.aspx
It is easy to interface with Arduino and you can set the serial post speed up to 128.000 byte/sec !