02-20-2009 12:49 PM
I tried to use "open file" vi from File I/O -- Advanced file functions to open an excel file in LabVIEW. Why the excel file wouldn't open after I run the program?
02-20-2009 01:33 PM
Do you expect Notepad do be able to open Excel files when you select File -> Open? Well, same reason.
To read Excel files you need to use ActiveX. You can find examples in the Excel thread. If the data is tabular then you can save the file as a tab-delimited file from Excel and open it using Read From Spreadsheet File.
02-20-2009 01:46 PM
02-20-2009 02:15 PM
Thank you smer & venky for pointing me to the right direction. Haven't been program for long time...still using lv 6.
02-20-2009 10:38 PM
In addition to ActiveX, you can also manipulate Excel data files using the Windows ADO interface - a technique that is more robust, faster and IMHO easier. Do a search on the forum as there have been several threads within the last week or so discussing this very thing.
Mike...
01-15-2012 08:54 AM
Hello Sir. Do you have a version of that example in Labview 6.1? I am interested in learning however do not have the means to upgrade to the latest version. Apologies for the inconvenience, thanks for the help.
01-23-2012 07:20 AM
I may have some LabVIEW 6.1 code to interface with EXCEL. Not on this computer though. Give me a couple of days to look for it. You're right, it's been a long time.
01-23-2012 08:49 AM
Unzip and try the VIs in the attachment. I believe they will work, but I can't test them because I no longer have LabVIEW 6.1 on this computer. They haven't been tested with newer versions of EXCEL or Windows 7 either. They were probably last run on W98 or W2K. Good luck.
03-21-2012 03:34 PM - edited 03-21-2012 03:37 PM
Thank you Venkatesh for your posting! Much appreciated. I will check others as well. Thanks in advance.
07-01-2014 07:34 AM
Hi,
I have been playing with this vi as it is exactly what i need.
The question I have is, I want to run this sequence but instead of opening the excel file, displaying the data and then closing the excel file again, I want to keep the file open and update the displayed data when it changed in the excel sheet.
Can anyone help me to do this as I am not sure where or what alterations I need to make?
thanks in advance
Nathan