Hi
I’ve been looking into streaming data from a UNO into Microsoft excel .
Presently my Excel is an old version , before I buy a later type , has anyone recently had any success doing this .
The stuff I find in the internet is confusing and it looks it’s only possible now if you have a 365 account to use the add in Microsoft which I don’t want ) ????
Can anyone advise ??
Whenever I need to do this I use a program called MegunoLink.
There is a free trial period.
There is a project in the "project hub" that sends data to excel.
Link arduino-to-excel
I did try that before , but it only worked upto 2003 excel. It’s been updated I’ll give it a go .
Any thoughts on the MS add in ?
UPDATE : tried it , won’t run on my version of excel, even with security off- so in same position
I’ve used PLX-DAQ a while back with a pre 365 excel, it did what I needed.
Have not used it for a few yew years.
You probably have seen this long thread.
PLX-DAQ version 2 - now with 64 bit support! (and further new features)
Yes, I have.
I can confirm that Microsoft Data Streamer for Excel is only part of Microsoft 365.
You have to add it in 'options':
When I first heard of Data Streamer I updated to office 365 as it was called then, just for this feature.
Yep ,
I’ve fallen in a hole . I have excel 2007 , so both the early and later versions of PLX won’t run .
The MS addin did work with later versions of Excel , but it appears not now that 365 is around , and I don’t want to get into paying subscriptions for office .
I’m sure if I had the skill( I haven’t ) a VBA script would do the job ?
I have in the past saved as text file in a SD card , but wanted to try this .
Is there a way to realise this via openOffice?
Here's an example I've just done:
I am sending a 20mHz signal from a function generator to analogue input A0.
Analogue readings are taken every second, and sent to the serial port using Serial.println().
The graph that I have inserted into that sheet will update just like the serial plotter does.
Using that 'Record Data' button you can store a much longer file.
You can get a months free trial of Microsoft 365.
Like you I didn't like the idea of subscribing, but I tried it, and liked the results.
That experience changed my ideas about subscribing to Microsoft 365.
We have subscribed to 365, ≈ $100 per year here, it beats the old days when you bought a new version now and then and got 100 pounds of manuals 
.
Nothing I’ve found
That's not right. I believe the old version was good up to O2003, and Netdevil's v2 was specifically made for subsequent versions, which definitely includes O2007. You should check the megathread.
He only says what he has tested it on , which are later versions , but I’ll look for that thread .
I did down load it , when I open the file ( xlsm) excel just closes .
Macro Security on lowest settings.
This thread has drifted into PLX-DAQ and whilst searching remembered I had a response from the author last yr “ Spoke to the author , it has not been tested on 2007 and may just be too
Old .”
Looks more promising if I buy a later office - prob my best /only option at this point
Maybe I was wrong about when M$ changed the structure of Office, but I find it more than passing strange that it has taken all these years to find that O2007 falls between the two versions of PLX, particularly as I'm sure it was not that outdated when v2 first came out.
If I am indeed wrong about Microsoft, I guess there's a (faint) possibility that the original PLX will work for you.
@Nick_Pyner I have 2007 which works with PLX DAQ for me, it has it's limitations but works fine for data logging at a moderate pace.
If your collecting data at a faster pace over a short period of time then in my opinion your better writing data to a file with a custom app.
So, are you talking about the original PLX DAQ or NetDevil's v2? I'm not actually the guy with the problem and am surprised Hammy has his. I'm an Office 2000 man and use the original macro. It never occurred to me that there could be a problem with frequency, but a 1 second loop is all I use.
@Nick_Pyner not the original PLX DAQ, I used that with a Basic Stamp, but NetDevils comport modifications work quite well beyond that.
I would say a 1 second interval is great, I think when data is written into Excel it updates the whole sheet so when the data comes in too fast it causes problems between the display and the serial comms fighting for cpu time.
That's the way I have always visualized it anyway and is how I came to the conclusion that writing to a csv file was a better option, it fell between PLX DAQ and an Oscilloscope. I have not tried Office 365 that could possibly be a great improvement.
I actually programmed a VSTO add in but it never got much better than NetDevils work which again I thought was because of the worksheets memory requirements.
Maybe I’m doing something stupid .
I just load the xlsm file , either by clicking on it , or loading from excel
And excel just crashes out .
Win10 and excel 2007.
Both versions of PLX produce the same result ( the early after installation ) macro security at min .
