Last line/column in Excel

[bbel91]

Bonjour,

A partir d'une feuille Excel ouverte depuis Labview (v8.5) comment faire pour récupérer la position de la dernière cellule de cette feuille ?

Actuellement, je lance une macro depuis Labview en même temps que la feuille dont je veux connaitre la taille et cette macro me donne la dernière cellule. C'est un peu lourd...

Dans la même idée, y-a-t'il un moyen de lire une feuille Excel plus simplement qu'en passant par un ActiveX ?

Merci pour vos réponses.

[bbel91 · Accepted solution]

(in English) 

Hi,

From an Excel sheet openned from Labview (v8.5) how can I get the last cell position of this sheet ?

Actualy, I run a macro from Labview together with the sheet for witch I want to know the size and this macro give's the last cell. It's a bit incomode...

In the same idea, is it possible to load an Excel sheet withouit using an ActiveX ?

Thanks for your answers.

[Harold_Timmis]

you could use the report generation toolkit they have an evaluation copy of it on NI.com

[bbel91]

Thank you for your answer Harold but this toolkit is a bit expansive comparatively to my demand.

Perhaps later...

[Harold_Timmis]

this board may be able to help you in this board there should be a LabVIEW LLB it is a excel Library

http://forums.ni.com/ni/board/message?board.id=BreakPoint&message.id=2391&query.id=53873#M2391

[smercurio_fc]

---

bruno.bel wrote: 

From an Excel sheet openned from Labview (v8.5) how can I get the last cell position of this sheet ?

Actualy, I run a macro from Labview together with the sheet for witch I want to know the size and this macro give's the last cell. It's a bit incomode...

---

If you already have a macro you could simply duplicate the code the macro does by calling the same properties and methods via ActiveX.

---

In the same idea, is it possible to load an Excel sheet withouit using an ActiveX ?

---

Short answer: sort of.

Long answer: depends on what you mean by "load". If you just want the values then you can save the Excel sheet as a delimited text file and then simply use the Read From Spreadsheet File VI. You can also use DDE, though that's an old and outdated technology. You can also treat the Excel sheet as a database and use database-related technologies like ADO. Search around the forum as examples have been posted. 

[bbel91]

Thank you Harold & Mercurio, I think that I've found what I want in the forum's links you give me.

Now I will try the VIs I've found.

If all is Ok, I'll close this message.