How to get the range of data from excel files with labview?

[TomWang]

hi,

i understand by using ADODB._Recordset i can get the number of columns and rows from an excel file, but its there any to get these using
excel._worksheet or excel._sheet?

so i can automaticly set the rang for it to read instead of setting them myself everytime i open an different excel file.

Tom Wang

[MikeS81]

Hi Tom,

do you mean like this? With this example you can read the used range of the active sheet.

Hope it helps. Mike

Message Edited by MikeS81 on 06-19-2008 11:45 AM

[TomWang]

Wow Thank you again lol...

it will take me age to come something like that...

where can i find all the information of all the class and models?
the microsoft help does not come with much on the activeX for excel.file only ADO...

[TCPlomp]

You should install the VBS help for MS office. This will give direct source from LabVIEW (if I'm not mistaken) to the help.
Otherwise you can browse this info from the Excel VBS editor.

Ton

[Joe_H]

Another thing that you can do is to create a macro in Excel and then duplicate it using properties and methods in LV.

For more information and some sample VI's and tool kits, you can go to the excel board

[TomWang]

thank guys i will try that...

[vasgeo]

Hello everyone,

I have the same problem.

I would like to make the LabView program to set automatically the range of an excel file instead of stretching it every time when a new excel file is opened.

I'm using a program Extract Excel Data 2010by JDruba and trying to adjust it but I got stuck.