Answer / uday

The Question is to retrieve a cell value from Excel sheet.

The method which does this is:
XLSheetObj.cells(rowno,colno).value

Answer / pravati

set excel=createobject("excel.application")
excel.application.visible=true
excel.workbook.open("path of the excelsheet")
set mysheet=excel.activeworkbook.worksheets("sheet name")
value=mysheet.cells(row no,colmn no).value
msgbox value

Answer / ram.polavarapu

'count the number of colums
cc=browser("").page("").webtable("").columcount
'count the number of rows

rc=browser("").page("").webtable("").columcount

for i=1 to rc
for j=1 to cc

'to retrieve all data from excel sheet
n=browser("").page("").webtable("").getcelldata(i,j)
print n

'for example we need to retrieve from 2-row 5-colum
m=browser("").page("").webtable("").getcelldata(2,5)
print m

How will you handle java tree in qtp?

0 Answers  

---

How to do Batch run in qtp? provide the steps?

5 Answers  

---

What is action?

0 Answers  

---

HI. AnyBody can explain Automation Testing Framework...Generally wht do we Intiate before going to start Automation testing process... Anybody can explain.......Thanks in advacne...

1 Answers   HCL,

---

what is descriptive programming? what are the mandotory properties in qtp? what are libriry functions in qtp? what frame work you are using at your project? what is object repositery? what is our role as per qtp project is concerned as a software tester?

3 Answers   Wipro,

---

Hoe to generate all numbers in between to numbers suppose all numbers in between 1 to 100 using vbscript give me code

2 Answers  

---

how will you load the test cases in ddt?

0 Answers  

---

How many ways we can parameterize data in QTP?

1 Answers   Crea,

---

HOw to add the recovery file at runtime to the test file .

0 Answers  

---

what are the 5 types of objects in qtp

6 Answers   ABC, TCS, Wipro,

---

How i can use Regular expression in QTP?give detailed steps for it.

2 Answers  

---

After running scripts how you report results ,there is any specific report form

1 Answers  

---