Writing XY Graph data to Excel

[schreineradam]

My VI (which I have included) acquires data and displays them on an xy graph. What I would like to do is for these data to be written to an excel file as well whenever the user sets the "Start/Stop Plotting" to true. What would be ideal is for the data written to be the last measured array of data, and have the data be overwritten each time the user starts plotting. I hope this makes sense! Thanks for your help.

[mikeporter]

There are at least a couple ways of getting what you want.

1) You can simply save your data in a file with an *.xls extension. Excel will then open it as though it was a file of its one of its own.

2) You can use ActiveX to write data to a spreadsheet. The big problem is that over the years the ActiveX interface for Excel has tended to uh.... "evolve". The result is that you can write a routine to do what you want and then Excel gets upgraded and everything stops working.

Mike...

[schreineradam]

I'm not sure exactly what you mean on that first one. I don't know how to save the data into a file.

[mikeporter]

See the attached...

Run the VI and then try opening the resulting file in Excel.


Mike...