get last used row from excel file with OLE connection

[paulo_green]

Hi there

I am  creating a scritp  in Diadem and I need to copy  a column of values starting at a specified row until the last row with value from a excel file and save it in a variable in Diadem. 

I have tried for quite a while and searched in many foruns but so fare i have not found the right sintaxe to obtain the number of last row with values. I hace created a new object "excel.application" and i am using a OLE connection.

Thanks

Paulo Senra

R&D 

Green Power Tech. 

[Brad_Turpin]

Hi Paulo,

I'm not sure about the native Excel ActiveX command, though I suspect there is one, but if you instead use a DataPlugin with the built in spreadsheet reader to parse the Excel data file, then there is a command I use frequently to do this.

Brad Turpin

DIAdem Product Support Engineer

National Instrumets