03-09-2006 04:27 AM
03-09-2006 11:38 AM
03-09-2006 12:45 PM
Thank you
I have tried that Read From Spreadsheet File.vi it is just reading values i mean numerics not string like green or red, So i m thinking how to read string and values and then compare with valuses i take from DAQ board. Reply me if you have any idea...
03-09-2006 12:50 PM
03-09-2006 12:53 PM
Look at the instructions on the diagram of Read From Spreadsheet file for the modifications required to change it to read strings. When you do this, you will get a string array (2D and 1D) back. You can then convert the columns with numbers with something like Fract/Exp String to Number. When you make the changes to Read From Spreadsheet, be sure to save it with a new name and in a different location. If you get really ambitious and you have the pro version of LabVIEW, you can create a polymorphic VI that will do either.
03-09-2006 01:57 PM
Thank you for taking interest but I realy dont understand both solutions could you explain it in littel bit in breaf to be honest I am new to LabVIEW..
Thank You
03-09-2006 02:04 PM
03-09-2006 02:47 PM - edited 03-09-2006 02:47 PM
Message Edited by tbob on 03-09-2006 01:48 PM
Message Edited by tbob on 03-09-2006 01:48 PM
03-09-2006 02:55 PM
Before you read the instructions below, you really, really should check into some of the resources for learning LabVIEW. Go to http://www.ni.com/devzone/lvzone/fundamentals.htm and look into all of the various options for official classes and web tutorials. The modifications required are some of the simplest tasks in LabVIEW and should be considered basic skills that you need to write and debug you own program.
Okay, open Read From Spreadsheet file by first dropping it to a diagram and double clicking the icon. Go to the diagram and on the control labeled "type (empty)", right click and select Show Control. On the front panel, right click on one of the numeric indicators in the "all rows" 2D array indicator. Select Replace and select String Indicator from the Controls palette. Do exactly the same thing with one of the numeric indicators in the "first row" 1D array indicator. Do exactly the same thing on the (now visible) "type (empty)" control. Right click on "type (empty0" and select Hide Control. Go to the string control labeled "format (%.3f)" and change to %s. Right click on this control and select Data Operations>Make Current Value Default. These are all of the changes requied. You now have to save the VI. Go to File>Save As and select a new name (i.e. Read Strings From Spreadsheet File) and save it to a new location. Do not save it in the same folder. You can save it in in the User.Lib folder or any other place on your local drive.
03-09-2006 03:54 PM