How to retrieve particular cell data in excel sheet ?without importing method.
Answer Posted / 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 This Answer Correct ? | 2 Yes | 4 No |
Post New Answer View All Answers
How to write business scripts using object repository with different scenarios
How to use actions in qtp ?
Can anybody post some real time scenario in qtp? please its very urgent.
write script for bitmap image?
Write a QTP script to enter a keyword in to Google search engine?
How you can decide which type of object repository you have to use?
What are the advantages of qtp?
Hi, I got error message as "object does not support this property or method: "Test.Actions" when i execute the following line of script on QTP 9.0 Dim qtApp, qtRep Set qtApp = CreateObject("QuickTest.Application") Set qtRep = qtApp.Test.Actions("Action1").ObjectRepositories Can anyone tell me where i am wrong.
I want to do Certification course in QTP. For this I request you to suggest the best Tutorial in PDF format. Hence, if possible, kinldy mail PDF file to my mail-ID: sushmapokhriyal79@gmail.com
we add library file used in test via settings or through "ExecuteFile" command. when we implement framework do we make common library file and load the same for all the test cases execution?
In application which areas to be automated and what kind of situation will be take? using QTP? Plz give me the clear answer
How does qtp identify the object in the application?
Which is the best QTP training institute in Delhi/NCR region and what is the approximate fee for QTP course (Basics and Advanced)
Mention the different actions types of qtp.
Explain in brief about the quicktest professional automation object model?