excel automation refnum

[Citramon]

Hi all

sorry for this stupid answer, but i'm just beginner in LabVIEW...

I need to open and then to use  data from excel file in my calculus

I read that it possible with automation refnum, but I can't do it

Anybody could show me example how I can connect my excel file with automation refnum?

[egraham]

I would suggest one of the quickest ways is to save your Excel file as text and use Read From Spreadsheet File.

[Citramon]

Thx for your advice, I know this way

but i will have xls file on remote computer, and it will be refresh sometime, so it isn't good to change format from xls to txt everytime

[leumaseoj]

hi citra,

Actually I dont know your requirement.... But try this...

Try 1

Try2

<<Kudos are welcome>>

[Citramon]

Hi Electro SAM, i have tried, but nothing for me...

Someone can help me with automation refnum? plz

[Ashwin_S]

Hello Citra,

If you want to just read/write the data in EXCEL, do not go for ActiveX (What you call as an Automation).

Follow this link to get basic idea of using Excel ActiveX reference in LabVIEW

http://decibel.ni.com/content/docs/DOC-15380

AshwiN,

[Citramon]

thx Ashwin S

i think it's normal variant for my task

but i can ask u? if u can of course do this... convert this file from LV 8.6 to 8.5

[smercurio_fc]

---

@Citramon wrote:

Hi Electro SAM, i have tried, but nothing for me...

Someone can help me with automation refnum? plz

---

What exactly have you tried? In order to control Excel directly you either do it yourself using ActiveX or you can buy the Report Generation Toolkit. Depends on how much you need to do, and whether the cost of the Tookit is worth it. There are a couple of examples that ship with LabVIEW. Have you loloked at them? The Excel thread that was linked to before provides MANY examples. Please note: DO NOT POST in the Excel thread.

[Citramon]

smercurio_fc i have used search, read this topics, but if u read my topic from beginning you'll know about my skill in labview

who can save LV86 file for LV85? plz

[egraham]

Here you go. There's also a thread for down convert requests...