Answer Posted / pankaj

Call the excel first :
Set xl = createobject("excel.application")
Set wb = xl.Workbooks.Open("D:\test.xls")
Set ws=wb.Worksheets(sheet1)
datatable("Colname","Sheetname")=ws.cells(i,j) ' i and j
'would be known row and col into excel

Try this it will work for more doubt in QTP you can directly
post me question on my blog
http://quality2deliver.blogspot.com

How many types of recording facility are available in quicktest professional (qtp)?

1068

---

Does Low-level recording capture mouse movements?

1055

---

How do you handle multiple banners(at the top the page, the banner is scrolling) in a web page(Dont take the name property(regular expression))

2111

---

hi guys, pls tell me for testing institution training hub, hitech city is best or not?

1830

---

If I change the object name in one action will it be updated in all the actions? Or not?

1076

---

Pls can anybody send me the Recent Technical and Interview Questions Which were asked in IBM(QTP)Automation PLZZZZZZZZZ

2037

---

please post the interview questions for QA position in FACTSET

4451

---

Without using gui map editor we can recognize the application in winrunner ?

1062

---

How to create Reusable and Multiple Actions?

2200

---

What will be happen if i load object repository at run time, but it has already associated.

1792

---

if numbers are always changing write a script for that

4214

---

what is profile tool?

2237

---

HI Everybody, I am using QTP 9.2, I have a problem and hope everybody help me solve it. Now I need to use mouse wheel event to zoom in or zoom out in web client, but QTP can't catch this event. I look forward helping of everybody. Thank you very much.

2198

---

This is Karthic and my mail id is karthic.venkitapathi@gmail.com, please give me an idea to crack qtp 10

2015

---

How to check feasibility of the appliction?in automation testing?

1990

---