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

I am facing an issue of object identification with the dropdown element of DHTML grid. When I tried to recognize these different dropdown objects, QTP identifies only one object for all the dropdowns. Hence, selection of different data from different dropdowns list is an issue. To overcome this problem, i have used Descriptive Programming technique by creating different object descriptions which have all the other properties same but differ only in one property i.e. ‘X’ location of the element on the screen. Hence, i have created distinct object descriptions that would allow us to select values in different dropdowns. The code is given below. But still I am unable to identify distinct dropdown objects. ‘Object Description for Dropdown Cell Status Set objCellStatus = Description.Create objCellStatus("micclass").value = "WebList" objCellStatus("name").value = "select" objCellStatus("x").value = 219 ------ ‘X’ Axis value for cell status drop down ‘Object Description for Dropdown Sub Segment Set objSubSegment = Description.Create objSubSegment("micclass").value = "WebList" objSubSegment("name").value = "select" objSubSegment("x").value = "319" ------ ‘X’ Axis value for sub segment drop down Please help... This is specific to DTML grid(Drop down object)

0 Answers  

---

which checkpoint we use to validate yahoo login screen window after login with ur id and password in qtp

8 Answers   Covansys,

---

what is Compile Module in QTP? what exactly it contains Functions or Actions?

1 Answers  

---

Hi All Below is my script which i made for lgin into Flight.exe. SystemUtil.Run "C:\Program Files\Mercury Interactive\QuickTest Professional\samples\flight\app\flight4a.exe","","C:\Program Files\Mercury Interactive\QuickTest Professional\samples\flight\app\","open" Dialog("Login").WinEdit("Agent Name:").Set DataTable ("p_Text", dtGlobalSheet) Dialog("Login").WinEdit("Agent Name:").Type micTab Dialog("Login").WinEdit("Password:").SetSecure DataTable ("p_Text1", dtGlobalSheet) Dialog("Login").WinButton("OK").Click If Dialog("Login").Dialog("Flight Reservations").WinButton ("OK").exist Then Dialog("Login").Dialog("Flight Reservations").WinButton ("OK").Click datatable.Value(3)= "Incorrect password. Please try again" Dialog("Login").WinButton("CANCEL").Click elseif Dialog("Login").Dialog("Flight Reservations").WinButton("OK").exist Then Dialog("Login").Dialog("Flight Reservations").WinButton("OK").Click datatable.Value(3)="Please enter agent name" Dialog ("Login").WinButton("CANCEL").Click elseif Dialog("Login").Dialog("Flight Reservations").WinButton("OK").exist then Dialog("Login").Dialog("Flight Reservations").WinButton("OK").Click datatable.Value(3)= "Please enter password" Dialog("Login").WinButton ("CANCEL").Click else Window("Flight Reservation").Move 309,146 datatable.ExportSheet "C:\Raj\Result.xls" ,1 Window("Flight Reservation").Close End If I want to capture the Message string from Dialog("Login").Dialog("Flight Reservations" Also pls let me know if this is the right way to do the script for login. Pls provide some script for login Flight.exe Thanks in advance Raj Dhiman

1 Answers  

---

How reliable are the site's Internet connections required to be? And how does that affect backup system or redundant connection requirements and testing?

0 Answers  

---

How to send the qtp results file by email (Lotus notes).

1 Answers   TCS,

---

what is difference betweein qtp 9.0 and 9.2

1 Answers  

---

how to use command prompt using qtp?

8 Answers   HCL,

---

what is reusable action and how the same can be implemented (process)?

2 Answers  

---

how can we retrieve ten rows from the data table using loop concept?

4 Answers  

---

what is aregular expression?

4 Answers   UHG,

---

where the object repository is located?how to choose the object repository as shared or action object repositories?

4 Answers   Datamatics,

---