Reading Specific points from spreadsheet

[RileyC]

Gday.

I love some help on how to extract specific data points from an excel spreadsheet output.

Basically I run my program. Ive used the 'Write to measurement file VI' to save the data to an excel spreedsheet.
Then the 'Statistics VI' along with some basic formulas gives me two readings in respect to y axis data (x axis is only time).

Is it possible to have the 'read from spreadsheet VI' reference back to the two readings ive found and give me the corresponding x axis (time values)??
I only need to read two values from the data saved.

Much Appreciated

Riley

[Pedro89]

Hi RileyC,

can you save the file in LV 8.5 format? I can't open your version and as such can't help you. Also: how is the data you're saving separated?

Regards,

Pedro

[Szklanam]

If I understand what you mean, you should be able to use the "Array Subset" to extract certain elements or a box of elements. The four terminals on the left from top to bottom are the row index, the length starting at that index(so how many rows down do you want to go) then the column index followed by the length (how many columns to the right do you want to go). Then you can output just a subset of that initial file. Remember labview is zero-based though. Hope this helps. If not, sorry.

[RileyC]

@Pedro.
Ive attached a previous LV version of my VI. Hopefully it works for you.

@Szklanam
Yes thankyou. that helps alot. I will give that a try and hopefully it will work.