reading a value from spread sheet

[Vikaspeddanagiredy]

Hi,

                      Can you please suggest how to select a particular spreadsheet file out of three files  and read values from the selected spreadsheet file.

Thanks in advance

[P@Anand]

I'll give you 2 clues to make what you want.

1. You can use File Dialog function for selecting the spreadsheet file.

2. You have a direct VI to Read from Spreadsheet.

Lets see how you make it.

[REAL!]

Hi,

I guess it depends on if the files are user selectable or if you want LV to automatically select the correct file to load?

Either way, opening the spreadsheet is easily done with the normal LabVIEW vi's.

Darren.

[LV_user1]

You can use read from spreadsheet.vi to perform your task.

[mikeporter]

Yes, but....

It also depends on what the format is of the actual file. Some people will create ta-delimited text files with the .XLS file extension and Excel will sometimes open them without complaining - thus leading to the impression that they are really spreadsheet files.

So the first question is are the files really spreadsheet file, or text files that you can open with a spreadsheet. 

If it's the later, please pardon my interruption...

Mike...

[Vikaspeddanagiredy]

Hi,

      Actually the file is a spreadsheet file stored as .csv file and it contains an array of values.

[P@Anand]

Did you give a try what I have suggested? Its straight forward, please check and comeback if you face any issue.

[Miraz_Automation]

Hi,

Please find attached VI, 2 files and code image (if you do not have labview 2010), one is.CSV file and other is without extension (can be opened in notepad).

just run the VI, it will ask you to browse the file and then it will display data inside the file in an array.

Miraz....

Kudos is better option to thank somebody on this forum.