reading a text file through XL

[IBAHKA]

Hello,
Does anyone know which invoke nodes I should be using to read data from a text file though an XL file. I would need to import the data into XL and then use the data.
Thank you,
IBAHKA

[Joe_H]

Here are some examples I hope they help.

[IBAHKA]

Thsnks, but the examples did not help. They showed me how to open an XL file in LabVIEW. I am familiar with this. My difficulty is importing data from a text file to an XL file.

Thanks

[Joe_H]

If you would have looked it is a whole toolkit for excel. In the zip file is some examples find example 1 and it shows you how to take a text file and put it in excel.If you need anything else or if I'm not understanding your question correctly then let me know.

[Dennis_Knutson]

The other thing you can do is look at the Excel documentation. All of the properties and methods are described in the Visual Basic Help. A quick search finds that one of the methods of the Workbooks class is OpenText. Give it a filename and delimiter information and see if that works.

[IBAHKA]

Hi Joe,
Thankyou for the clarification. I was able to upload all the vi's , however I wasn't able to run example1.vi. i changed the beginning of the program. I added two choose file controls to choose the text file and excel files. I am not sure if I need the NAC constants that you have in the program, and for location you have a constant NAC_... Do I need this as well?
I'd appreciate some clarification about the program.
Thanks! Enjoy your day!

Ivanka

[IBAHKA]

Hi Denis, I tried this as well. However I would get an error saying that a nul reference was passed from that invoke node. I couldn't access the data that was opened.
I'd appreciate your input. Thanks, Ivanka

[Joe_H]

I got this example from the web. When you are trying to load it I bet it asks you for A VI called ecel open or something like that like it did me. If it does just use the ecel open in the provided llb it is exactly the same thing. When you run the program you will see that all these constants do is tell excel where to start putting the data you do not need them for your program. If I can help you anymore just let me know