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 many types of recording facility are available in QTP?

1 Answers  

---

How to invoke QTP using Dos prompt ?

2 Answers   ABC,

---

Could anyone help me for the below scenario: i am using the descriptive programming for my account, in which we have to generate the contract in the MS-word. when i generate this doc, we need to click on enable macros to continue further. but i am unable to make qtp to click on this. if anybody faced the problem like this??? pls help to get it resolved? Thanks in advance

0 Answers  

---

How do I get the QTP scripts result in xml format by using vb script function?

0 Answers  

---

How to get data line by line from web element

2 Answers  

---

What is the Test Object model in QTP?

3 Answers  

---

I am using descriptive programming for my project.when QTP deosn't identity or recognize a object by record and playback method,is it possible to make QTP identify that object using descriptive programming? Note: The object doesn't have unique properties and same properties used in Record and playback are only available, no extra properties are defined.

3 Answers  

---

What is the Difference between test object and run time object?

0 Answers  

---

what is Property......End Property loop? how to write sript for it in QTP

0 Answers  

---

What is log file?How to write log file code?

2 Answers   Apps Lab, Value Labs,

---

hi can anybody help with an qtp 9.2 license key please. Thanks, Nitesh.

0 Answers  

---

What are the points to be taken into consideration while doing desktop testing?

1 Answers   Cap Gemini,

---