1. Categories >> Software >> Testing >> Automation Testing >> QTP
  2. Suggest New Category

QTP Data Table Having 10 records with 10 to 15 fields(lets
say).now i want to get alternative records from datatable.pls
can any one answer it?

Question Posted / pushkar1206

Answer Posted / pushkar1206

datatable.AddSheet"pushkar"
datatable.ImportSheet "C:UserspushkarDesktopBook1.xls","Sheet1","pushkar"
rw=datatable.GetSheet("pushkar").GetRowCount
clm=datatable.GetSheet("pushkar").GetParameterCount
For i=1 to rw step 2
For j=1 to clm
a=datatable.GetSheet("pushkar").GetParameter(j).valuebyrow(i)
msgbox a
Next
Next

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is there any relation between Keyword Driven Framework and Recording modes provided in QTP( whether Recording modes are applied on keyword driven framework or not?)

1445

Hi, I have 2 dropdown listboxes called region and city/area. It needs to select one region(Santa Clara) and one city/Area (Sunnyvale).So I put this in the for loop and I am storing the Items in the variable called itemname. The regions value will get changed,so I used reg expression for this regions. This is my code Browser("MLSListings.com").Page("MLSListings.com").Link("ยป County/Area").Click Browser("MLSListings.com").Page("MLSListings.com").WebList ("regions").Check CheckPoint("regions") ListSize=Browser("MLSListings.com").Page ("MLSListings.com").WebList("regions").GetTOProperty("items count") For i = 1 To ListSize-1 Itemname =Browser("MLSListings.com").Page ("MLSListings.com").WebList("regions").GetItem(i+1) Browser("MLSListings.com").Page("MLSListings.com").WebList ("regions").Select Itemname ................. If I run the script,I am getting the following error, Cannot identify the specified item of the regions object. Confirm that the specified item is included in the object's item collection. Any Help? Thank you, Uma

1339

What are the different properties of an web object

1421

To which environments does quicktest professional (qtp) supports?

581

What are the various automation frameworks available in qtp?

499




Hi All, How to Compare two strings character by character in QTP

951

what is the difference between data driver & data driven and driver script?

2132

What are the advantages of qtp?

574

can i compare two databases using QTP ?

1873

Write a script to customize the test results in PDF and HTML format.

2082

How many add-ins comes by default with qtp?

532

Tell me about qtp?

536

Does quicktest professional (qtp) is unicode compatible?

534

can test automation improve test effectiveness?

1480

i have to login into gmail loginpage i have to pass testcase into userid and password by using functions. the test case of user id is it should take only lowerletters alphabetin between 4 to 6 length.it should not take spectial letters.it should not take numbers.testcase for password is it should take numbers and it should not take alphabets note the following things must happen 1 when i give correct password and userid that password and userid should be seen in QTP result and notepad,xl sheet 2 when i gave in valid password the system willgive message please give valid password that particular messaage should be seen in QTP result,norepa and xl sheet

1750