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,...?
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.
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?