Excel Data to Waveform Graph

[cjack]

Ok, I have a spreadsheet with temperature data logged every ten seconds.  What I would like to do in LV is open the file, go to a particular cell in the spreadsheet and plot this data in a waveform graph.  I've tried several different configurations and looked over the examples numerous times.  I just must be missing something!!  Can someone please help?

Message Edited by cjack on 08-11-2005 11:07 AM

[Will.D]

You should try reading the whole excel file first, then just index the (presumably) 2D array to obtain each element.  As it would appear you're just doing this one at a time, try using an XY graph...  unless you DO need this real time...

[cjack]

I'm sorry, I have a million things going on at once, I meant to say I want to be able to locate a certain column and graph that data.  I've attached one of the configs I've tried.

[Will.D]

Well, once you get the whole file into an array, do you know what you're looking for?  Will the column always be in the same place, or do you need to search for a particular flag or value?

If the column is always going to be in the same place, then just use what you've got, but resize the index so it only gives you one array, and specify the column index.

[cjack]

Ok, I got it to work.  One more thing if I have text in the first row, how do I get it to skip that row before it starts reading the data to the graph.  I tried the off set feature on the Read From Spreadsheet vi but couldn't get it to work correctly.

[Will.D]

Well, since you've got a 1D array of values which was a column, just use "Array Subset", and wire 1 to the index, and leave the "length" input at its default (rest of the array), and you'll have the proper data.

[cjack]

Thanks, much appreciated!!