Simple as possible Live datalogger

Projects Interfacing w/ Software on the Computer
1

Hello i've been looking all day for an answer but no success yet. (it's probably my fault)
I'm new to arduino and done very little programming but been into electronics for a few years as a hobby and done plenty reading/research, Anyway.
Arduino UNO
Win 8
Usb connection

i load the ReadAnalogVoltage example and use a pot to vary the input, open the serial monitor and sure as shit the information is there at specified intervals etc. brilliant!

All i wanted to do today was have that information stream into excel (ms excel 2013)
.....Well what can i say its 7.30pm and i've achieved nothing other than to confuse myself ive investigated "coolterm","Processing","gobetwino","PLX-DAQ" and watched about 3 hours of bloody youtube but i cant make any of them work. i've tried copy and paste and looking at others examples to see whats involved and i cant beleive its so complex! (maybe a fool)
i just have no idea where to start now
Could anyone help my poor little brain and offer some code to paste.
i'd like a column for time and a column for the data (0-1023 from A0 input) thats it.
i wouldn't mind if i could even store the info and just open with excel later. i just need to get the ball rolling.

Thanks for any help sorry this has gone on a bit.
Andy Thicko

2

What does your arduino code now looks like?
Can you post it?

3

The PLX-DAQ process is an addin for Excel that does not work with Excel 2013. It only works with older versions of Excel.

As to why you couldn't get Processing or coolterm to work, I suspect that your brain of fried from all the you-tube crap.

4

apbosh1:
Hello i've been looking all day for an answer but no success yet. (it's probably my fault)
I'm new to arduino and done very little programming but been into electronics for a few years as a hobby and done plenty reading/research, Anyway.
Arduino UNO
Win 8
Usb connection

i load the ReadAnalogVoltage example and use a pot to vary the input, open the serial monitor and sure as shit the information is there at specified intervals etc. brilliant!

All i wanted to do today was have that information stream into excel (ms excel 2013)

If you want to write a true Excel file *.xlsx, then How to automate Excel from C++ without using MFC or - Office | Microsoft Learn may be useful.

If you are wanting to write to a CSV file *.csv that can be opened by Excel, then Inkling maybe useful.

5

apbosh1:
All i wanted to do today was have that information stream into excel (ms excel 2013)

see post from cathalcl nearby. The only advantage of PLX_DAQ into Excel is live graphing. Other than that, using RealTerm to produce a CSV file for Excel will do just as well and, if you can send data to the serial monitor that looks right, there should be no problem with making a kosher CSV file.