loading data from excel/notepad to display on waveform chart

[holla]

Hi all,

Im using Labview 8.2 and very new to this software. I was wondering if i could load the data i saved in notepad/excel to be able to display on a waveform chart?

holla

[mikeporter]

The answer is a definite "maybe".  It all depends on the format of the data in the notepad/excel file (I am assuming that you mean a delimited text file that you are opening with excel). If the data in the file is simply tab-delimited you can read the whole file into LV as a string and then turn the string into an array using the spreadsheet string to array function.

If the data is in a file that is in the native excel file format, you can still get at it from LV but it will require you to write code using ActiveX connectivity to communicate with excel. This code is more complex and will probably break if you upgrade excel.

Can you post a short excerpt of what your data looks like?

Mike...

[Rajan_77]

Hi holla

attched VI & tab delimited file. hope it answers ur queries.

Please change the path of the trial.xls file appropriatly.

Regards,

Rajan

[holla]

Hi all,

This is what my data looks like

[Dennis_Knutson]

This is about as simple as it gets with reading and graphing a file. This will display all of the data you saved. You can modify it as you like if you want to only show a portion. A graph is better for this than a chart.

Message Edited by Dennis Knutson on 08-05-2008 08:51 PM

[holla]

I get what u mean. But im stuck at the waveform part. I tried connecting it but it has errors. Any help??

[RavensFan]

Please provide a little more description as to what errors you are getting.  The VI opens fine and the Run arrow is not broken.  You do have a lonely Read Spreadsheet File hanging out there not connected to anything else.  I thought you wanted to "load data from Excel/Notepad to display on Waveform Chart", but most of the code present in the VI is to generate a text file with random data.  You will need to create a separate VI to do the data loading and displaying.

[holla]

Where do i connect the read spreadsheet file to?? Any examples on how can i do the data loading and displaying??

[RavensFan]

Okay.  This is pretty much meaningless as it writes it out and immediately reads it back from the same file.  But it should show you how you would use the Read Spreadsheet File function if you were going to use it in a real VI.

[holla]

What must i do if i dont want the graph to be shown simultaneously?? What u gave me is when i press play, the graph will be shown and when stopped it will be shown on the other waveform chart. Meaning i can open up the file that stores all the data anytime and just read it on waveform chart 2.