08-12-2009 10:20 AM
Hi!!!
I want to read the data ( string type) from my excel file. please tell me what VI to use. Is there any other data type where i cn string as array??? And recover it easily. Thank you.
Solved! Go to Solution.
08-12-2009 10:24 AM - edited 08-12-2009 10:25 AM
Is your subject line a Freudian slip about the quality of your data (or Excel)?
There are Avagadro's number of posts about this subject on the forum, search 'Excel' on the forums or LV examples.
08-12-2009 10:33 AM
Are you dealing with real excel files or just ascii table files written using "write to spreadsheet file"?
For real excel files, you need to use activeX, such as described here. Why don't you attach a small sample file so we can see what you have?
... and don't spread anything smelly. 😉
08-12-2009 10:33 AM
Hi Darin!!
Thanks for reply.I am a newbei for this software. I have information as string data type. I have stored my data in an excel file.I cant retrive my data. Is there any solution for this problem??
08-12-2009 10:34 AM
Hi Darin!!
Thanks for reply.I am a newbei for this software. I have information as string data type. I have stored my data in an excel file.I cant retrive my data. Is there any solution for this problem??
08-12-2009 10:52 AM
If you created the files with LabVIEW, then chances are that the files are not native xls type but just text. If you created the files with Excel, then you could save them as text and read them with the Read From Spreadsheet function. Otherwise, you would use the ActiveX functions that are in the above link. NI also has the Report Generation toolkit that you could use.
It would certainly help if you would attach the code you have written and one of the files so someone can see what is incorrect.
08-12-2009 11:06 AM
Hi dennis!!!!!!!
Sorry for late rpl. I m Uploading my files. Will you pls have a look on it?? I have entered data with the help of Labview. Now i want to retrive my data. I have tried ur files. but they didnt work. Thank ya
08-12-2009 11:18 AM
I don't have any problem reading the file with the "Read from spreadsheet.vi"
So can you please explain your problem again.
Thanks for that!
08-12-2009 11:21 AM
That's a text file with an xls extension. You just need to read it with the Read From Spreadsheet File function and set the type to String instead of the default Double.
08-12-2009 11:27 AM
Thanks yaar. Act it was very funny but i had no idea that i have to change to string type. Silly me
Thanks again buddy.