how to read and analyze spreadsheet data file

[wankyu]

I want to read a spreadsheet data file having two columns in order to analyze the data using Labview program. I am not an expert although I know some of Labview programming.

[aderogba]

I attach a sample vi to illustrate one of the ways you can go about reading your spreadsheet. There are additional examples in this forum and LabVIEW help.

[logman]

Aderogba submitted a good program, but you should note that if you want to read a spreadsheet file you will need to know how the columns are delimitted. Aderogba's program assumes a Tab-delimitted spreadsheet file. Tab-delimitted is one of the most common methods, but if you are using Excel (for example) you must specifically save your spreadsheet as a Tab-Delimitted Text file before you can read it in from LabVIEW.

[ran]

logman,
you've given a really good insight on the issue of reading from spreadsheet.

this is what i'm trying to do (using excel):
assuming the following is a spreadsheet created using excel ...

-----------------------------------------------------
Temp (deg F) | Pressure(sccm)| ...
-----------------------------------------------------
230 | 356 |
-----------------------------------------------------
1500 | 897 | ...
-----------------------------------------------------
784 | 1000 | ...
-----------------------------------------------------
987 | 2002 | ...

.
.

i want to be able to re
ad each column (for example) and pass on to another function to plot the temp values on a graph (as a example)


how do you save the file as a "Tab-Delimitted text file"? and how do i get it to read each column as "Temp" values or "Pressure" values?

thanks
-r