Prev: converting string of hexadecimals to numbers
Next: dll - performance issue
From: TomWang on 19 Jun 2008 05:40
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
From: MikeS81 on 19 Jun 2008 06:10
Hi Tom,
do you mean like this? With this example you can read the used range of the active sheet.
<img src="http://forums.ni.com/attachments/ni/170/333106/1/Unbenannt1.PNG">
Hope it helps.
MikeMessage Edited by MikeS81 on 06-19-2008 11:45 AM


Unbenannt1.PNG:
http://forums.ni.com/attachments/ni/170/333106/1/Unbenannt1.PNG
From: TomWang on 19 Jun 2008 06:10
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...
From: TonP on 19 Jun 2008 06:40
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
From: Jhoskins on 19 Jun 2008 10:40
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 <a href="http://forums.ni.com/ni/board/message?board.id=BreakPoint&amp;message.id=2391&amp;jump=true" target="_blank">excel board </a>
 |  Next  |  Last
Pages: 1 2
Prev: converting string of hexadecimals to numbers
Next: dll - performance issue