Run Excel and read file from excel to display on table

[zx]

Is it possible to launch excel and open a new document that shows a default header column for name and phone numbers?

Is it possible to read this excel file that was created and display onto a table?

If so, can anyone please show it to me?

[Kaustubh_vc]

Hi!
Your Half problem i can solve.
Find the attchment, you will get idea about how to open exel file and display in Table.

Kaustubh
VC (Pune)
INDIA

[tst]

If you open the example finder (Help>>Find Examples), you can find an example called Write Table to XL. It shows how to open excel and copy data into it. The same can be done for reading from excel (the Read VI can probably be found in the same LLB).
If you want to really have data as default, you should create a template in excel and open that.

[zx]

Thanks all for your help!

[zx]

What you gave me is quite complicated for me to understand. I am just a beginner. All I need is to read and excel file and display on the attached vi. Can you please show me how to do it?

Thanks!

[chilly_charly]

thread broken. Follows here http://forums.ni.com/ni/board/message?board.id=170&message.id=123994&jump=true

[Budgie]

Hi,

Please could anybody assist with my VI as I am new to Labview and appear to be going around in circles. I am simply trying to search the first column within an excel spredsheet for a specified value and illuminate an indicator if it is found (on front panel).

I have tried so many threads and previous posts but many seem far to complicated. Any help is appreciated but please understand I am a real novice!!

I have linked my own efforts for anybody to laugh at. Thanks

[LV_user1]

you can do it in this way....

hope this helps....

[LV_user1]

to zx...

excel can be read by using automation refnum as shown here....

may b it can help you....

[Budgie]

Hi,

Thanks for the help, it was all very useful although the error was due to my excel spreadsheet being in a .xls ? format and not a .csv format.  I also needed to put a (,) delimiter on the read from spreadsheet to separate values in adjacent cells on the spreadsheet. Anyway hey presto.....it works!!

Once again many thanks for your kind help.