How to open an excel file from labview?

[71cheeryhill]

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?

[smercurio_fc]

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.

[VENKATESH.J]

Hi,

You can open an Excel file using ActiveX function.

try out this VI and let me know if u have any queries.

Rgds,

Venky

[71cheeryhill]

Thank you smer & venky for pointing me to the right direction. Haven't been program for long time...still using lv 6.

[mikeporter]

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

[crazyintent]

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.

[djs_at_eaton]

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.

[djs_at_eaton]

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.

[psyboo33]

Thank you Venkatesh for your posting! Much appreciated. I will check others as well. Thanks in advance.

[n_wint]

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