Unable to import excel sheet to qtp

[abhis786hek]

I am getting error while I am executing following script:

DataTable.Importsheet

Code:

"D:\QTP_notes\class_notes\FlightProj\TestData\data.xls","login","Action1"
n= DataTable.GetSheet("Action1").GetParameterCount
msgbox n

'first line is importing my file to Action1 data tabel
but It is not able to execute second line.

I stored a file "data.xls" at given path but at the line I am getting general error.In data.xls there is one worksheet named as login and it contains 1 row.

I have attached the file too. I am not sure where I am doing wrong?

Please help.

---

Sorry 2nd line is:

Code:

n= DataTable.GetSheet("Action1").GetRowCount

I posted wrong in my previous post.

Thanks.