Forum Discussion

payaldalal's avatar
payaldalal
Occasional Contributor
16 years ago

Test complete should provide DDTDriverObj.RowCount

Hello AutomatedQA support, Test complete should provide DDTDriverObj.RowCount similar to DDTDriverObj.ColumnCount This thread is derived from 'DDT using Excel sheet' thread.Currently tes...
Ravik's avatar
Ravik
Super Contributor
11 years ago
Yes Ryan Moran ,



I am agree with you, I have also implemented something in VBScript.



Payal,



If you want to get the row count from the excel sheet you can follow the below approach-

 


Set  Exo=CreateObject("Excel.Application")


Set Wbo=Exo.WorkBooks.Open("Your Path")


Set Wso =Wbo.WorkSheets(1)


rowCount = Wso.usedrange.rows.count



Where -

Exo = Excel Object

Wbo = Workbook Object

Wso = Worksheet Object