LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

Retrieve data from MS excel

Solved!
Go to solution

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  

Message Edited by nolsqn on 02-24-2010 01:13 AM
Regards
0 Kudos
Message 1 of 12
(1,437 Views)
Highlighted
Message Edited by Mathan on 02-24-2010 02:44 AM
Message 2 of 12
(1,425 Views)
Highlighted

Have you tried the Activex method?

 

There are lots of example that could be found in this forum or @ni.com

 

 

Guru

Regards
Guru (CLA)
0 Kudos
Message 3 of 12
(1,419 Views)
Highlighted
You need not have the report generation toolkit and you can very well use the read from spread sheet. And use a write from spread sheet to write data as well....:smileywink:
0 Kudos
Message 4 of 12
(1,404 Views)
Highlighted

Dear nolsqn, is your problem solved? If so please mark which post helps you most in solving your problem.

 

Thanks,

Mathan

Message 5 of 12
(1,399 Views)
Highlighted
Read From Spreadsheet cannot read a native xls file. You must use ActiveX. Search the forum (there's probably thousands of similar questions. There is also the Excel Board.
Message 6 of 12
(1,390 Views)
Highlighted

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



Besides which, my opinion is that Express VIs Carthage must be destroyed deleted
(Sorry no Labview "brag list" so far)
0 Kudos
Message 7 of 12
(1,387 Views)
Highlighted

hi mathan my problem is well 50% solved ..........and yes your did help me a lot...

 

Regards
0 Kudos
Message 8 of 12
(1,352 Views)
Highlighted

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  

Regards
0 Kudos
Message 9 of 12
(1,350 Views)
Highlighted
Solution
Accepted by topic author nolsqn
Message 10 of 12
(1,345 Views)