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

Is there any option in QTP to add Java add-in after instaling the QTP?

3 Answers   IBM,

---

Can any one please list me out the shortcut keys for some functionalities in the QTP .. for example ..to record...to run...etc

6 Answers   Keane India Ltd,

---

what is the frame work your using in automation ?

4 Answers  

---

How to Test the mainframe application?(tell me few basic things)

3 Answers  

---

What are the types of Object Repository’s in QTP?

1 Answers   Crea,

---

What is difference between QTP 8.2 Obect Repository and QTP 9.2 object Repository?

2 Answers   Nokia,

---

What the differences are and best practical application of Object Repository?

0 Answers  

---

WHAT IS ETL TESTING.......

2 Answers  

---

Explain object spy in qtp.

0 Answers  

---

Can we continue functionality testing without framework?

4 Answers  

---

WHO IS THE BEST FACULTY FOR QTP IN HYDERABAD? A) NAGESHWAR RAO- MINDQ B) SURESH REDDY -SMART SOLUTIONS C) SURESH BABU- Q EDGE D) VENKAT - LIVE TECH E) GC.REDDY - HI-TECH CITY F) NONE OR OTHERS

7 Answers  

---

I have 2 Environment variable which holds int. I called into my test and addedup. but output is concatenating the values instead of Sum. Ex. Envi("a")= 10, Envi("b") = 20, c= Envi("a")+ Envi("b"). msgbox c ( Ans.1020). How to overcome this pblm? I used the add fn also..

3 Answers   BirlaSoft,

---