02-02-2010 11:06 AM
Hello All,
I am reading an Excel Sheet Data in LabVIEW but what i am getting junk data in LabVIEW.
Here with this I have attach the VI which is implemented to read the data as well as Excel sheet from which i am reading the data.
Can anybody please tell me why i am getting the junk data as a display and what is the solution to get the exact data as a display in VI?
Please help me, my project is in critical stage.
Thanks in Advance.
Regards,
Nishant
02-02-2010 11:11 AM - edited 02-02-2010 11:17 AM
Read from Spreasheet File DOES NOT read Excel files. It reads text files that are saved in a tabular format. If you open context help for that function, you'll see it says "Reads a specified number of lines or rows from a numeric text file ..."
If you want to get data from an Excel file, you need to either export the data as a text file, or use ActiveX methods to open the Excel File and extract the data from it.
There is an entire message thread listing links to different Excel messages.
PS. Your user icon appears as a missing image file with a red X icon. Don't use an image on a 3rd party website people can't get to. It actually slows down the loading of the page waiting for the browser to timeout when it can't access it. Attach your icon image to a message in this thread, then have your user profile point to that file attachment.