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

for a test in QTP i had choose the object repository as shared.after completion of some days i want to conduct the same test again,now the question is HOW TO LOAD THE OBJECT REPOSITORY. is it possible by descriptive programming.could any one tell me how many ways we load it and what is the process?

13 Answers   Logica CMG,

---

what is mean by soi in object identification

1 Answers  

---

Explain Checking XML....

1 Answers   Crea,

---

I have many listboxes in my application. I have to check whether the contents inside the listboxes are in sorted order or not..can anyone please send the code as early as possible

0 Answers  

---

How many types of Parameters are available in QTP? and Pls Explain with example.

4 Answers   LG Soft,

---

Please give me the steps to carry out datadriven in QTP8.2

2 Answers  

---

Why do we use breakpoints in QTP?

0 Answers  

---

Hi, Can anyone tell me what type questions can be ashed in interview on QTP?

1 Answers  

---

write script for , launching fr window,login and create 5 elements array and store 5 order numbers inthat array? and open order by using order no.s in array and find out maximum tickets booked by which order?

1 Answers   TCS,

---

suppose we recording a web based project so for that we are using internet explorer after that if we execute that script in netscape then script will execute or not and one more thing is to exeute the script in any browser what to do

2 Answers   DigiTech,

---

How to attach a file to TD?

0 Answers  

---

I want to clear the webedit field without using set"" in qtp script

1 Answers  

---