Retracting data from spreadsheet

[mpo]

Hi

i have data in my spreadsheet and i want to extract the date where the temperature value exceeded 29 and its time and date and store in another spreadsheet.

Please help

[Pnt]

If you can save your excel file as a .csv file , it will be easy for Labview to read it, with "Read from Spreadsheet.vi"

If you can not, then you have to use "activeX reference". Do a little search in the forum. It has been discussed many times.

You will find examples easily too.

[mpo]

Thanks for your reply. I can read from the spreadsheet file but the problem is I do not know how to pick only values with a temperature greater than 29. I did try to read the spreadshet as shown on the vi so I want to modifiy the code to retract those values greater than 29.

thanks

[Pnt]

The "Read from spreadsheet" will give you the strings in an array. This may help you.

If you can not use this vi, just scan your string, with the "Search/Split string" and then use the "Fraq/Exp String to number" to convert the string in a number.

[mpo]

I did manage to extract my data.

thanks for you support