02-24-2010 01:10 AM - edited 02-24-2010 01:13 AM
hi all
i have a simple question... how can i get data from an excel file ..... i have MS excel file (*.xls) i want simply to get data which is in that file in labview ?
i did go through the tutorial http://zone.ni.com/devzone/cda/tut/p/id/3181#toc0 but it seems that only way to get data from excel in labview is by having the report generation toolkit ...
or is there some way else that without having the toolkit i can read data from the excel ??
regards
Solved! Go to Solution.
02-24-2010 02:43 AM - edited 02-24-2010 02:44 AM
02-24-2010 03:00 AM
Have you tried the Activex method?
There are lots of example that could be found in this forum or @ni.com
Guru
02-24-2010 05:21 AM
02-24-2010 05:40 AM
Dear nolsqn, is your problem solved? If so please mark which post helps you most in solving your problem.
Thanks,
Mathan
02-24-2010 06:30 AM
02-24-2010 06:43 AM
I think it would less complicated if you open the file in excel, and then export it as a tab separated ascii file. Then you can read with basic Labview functions
02-25-2010 03:16 AM
hi mathan my problem is well 50% solved ..........and yes your did help me a lot...
02-25-2010 03:20 AM
hi
here are the two VI's that i made one using the read spreadsheet.vi and the other using the report generation tool kit ... what i want is to read the first column of the excel irrespective of the number of rows .........
the spreadsheet.vi donot read the native excel file
i am posting the 02 vi's please have a look , although they are working okay but actually i want you people to have a look at it and tell me how can i improve them
02-25-2010 03:32 AM