Answer Posted / vikas sachdeva

For this first u need to add a webtable in the object
repository and use this line

dim xl
set xl=createobject("Excel.Application")
xl.workbooks.open "c:/book1.xls"
set nsheet=xl.sheets.item(1)
row=Browser("browser").page("page").webtable
("table").getroproperty("rows")
cols=Browser("browser").page("page").webtable
("table").getroproperty("cols")
for i=0 to row-1
for j=0 to col-1
val=Browser("browser").page("page").webtable
("table").getcelldata(i,j)
nsheet.cells(i,j)=val
next
next

Have you faced any problems with object repository?

1012

---

How you can make an action as re-usable action?

1067

---

Is it possible to change the property value at runtime? How it is possible?

965

---

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

1045

---

What are the benefits of quick test pro(qtp)?

920

---

Explain about datafile/verification of date file when file is not available in local system?

2671

---

What are the ordinal identifiers in web page?

1074

---

Could you please any one give code for the following ? Scenario : Suppose a excel file contains 10 records and earch have 5 fields. how can i input this excel file for datadrive wizard ? Please explain

1893

---

What is the syntax to call one script from another?

992

---

How is the Bitmap checkpoint different from Image checkpoint?

1053

---

How would you export a script from one pc to another in qtp?

1049

---

how interviews will be on QTP?

1890

---

Get the count of files of similar types from a folder.

1420

---

How to import a test case present in ".xls" file to TD under a Test set?

1178

---

Explain the types of object repository?

938

---