cancel
Showing results for 
Search instead for 
Did you mean: 
Reply

How to read an Microsoft Excel file by LabVIEW ?

How to read an Microsoft Excel file by LabVIEW ?

Hi All;

 

I have captured some of the test data in Microsoft Excel. How can I read that data using LabVIEW and then do some analysis on that, such as FFT,...?

 

Thanks

Message 1 of 9
(23,746 Views)

Re: How to read an Microsoft Excel file by LabVIEW ?

cstudy,

 

there are several ways to read data from Excel:

1. Use ActiveX to open excel file and use ActiveX methods to read data if you have multiple worksheets in excel file. This is probably the most difficult way because it depends on ActiveX calls

2. Export data from excel to .csv file and then use LV functions to read the text file, parse the data and push it through FFT

3. Excel files are tab-delimited files and if your excel file has only one  worksheet, you may be able to treat excel file as tab-delimited text file, but that needs to be verified.

 good luck,

Serge 

0 Kudos
Message 2 of 9
(23,732 Views)

Re: How to read an Microsoft Excel file by LabVIEW ?

read Excel LabVIEW

 

A search is not difficult to do. 

Message 3 of 9
(23,711 Views)

Re: How to read an Microsoft Excel file by LabVIEW ?

 

I tried but it still does not work. Attached is a simple LabVIEW file. This file can read LV measurement file (.lvm) and proceed to do FFT but does not read Microsoft Excel File (.xls). How can I modified it to read Excel file?

 

Thanks

 

0 Kudos
Message 4 of 9
(23,657 Views)

Re: How to read an Microsoft Excel file by LabVIEW ?

Read some of the results in that search. You cannot read a native Excel file with the Read From Measurement File. You have to use ActiveX. The Report Generation Toolkit has functions for this. There are thousands of posts on Excel and ActiveX. A lot of posts/examples are in the Excel board.
0 Kudos
Message 5 of 9
(23,653 Views)

Re: How to read an Microsoft Excel file by LabVIEW ?

Please do not post search tools. It just brings up more and more search tools.

0 Kudos
Message 6 of 9
(2,316 Views)

Re: How to read an Microsoft Excel file by LabVIEW ?

Who are you replying to?  You resurrected a 7 year old thread.

0 Kudos
Message 7 of 9
(2,284 Views)

Re: How to read an Microsoft Excel file by LabVIEW ?

 is simply trolling -- creating yet another search link is not helpful.

Best answer is here:

<http://forums.ni.com/t5/LabVIEW/How-to-read-excel-file-in-LabVIEW/td-p/3244449>

see James Morris' reply

0 Kudos
Message 8 of 9
(2,262 Views)

Re: How to read an Microsoft Excel file by LabVIEW ?

No, he was not trolling.  He didn't get such a high ranking on the forums by being a troll.

 

Sometimes the best way to find an answer is by searching.  Fortunately it looks like you have much better search skills than the original poster who didn't seem to even try.

Message 9 of 9
(2,242 Views)