07-09-2014 04:47 AM
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
07-09-2014 04:54 AM
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.
07-09-2014 05:35 AM
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.
07-09-2014 06:41 AM
You can use read from spreadsheet.vi to perform your task.
07-09-2014 02:36 PM
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...
07-09-2014 11:01 PM
Hi,
Actually the file is a spreadsheet file stored as .csv file and it contains an array of values.
07-09-2014 11:31 PM
Did you give a try what I have suggested? Its straight forward, please check and comeback if you face any issue.
07-10-2014 12:57 AM
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.