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
what are the critical test cases in crm? tell me atleast 5 critical test cases? what are the critical bug u find out while testing crm domain?
Hi ,Can any one pleas explain how to test splash objects using QTP?
Define virtual object?
How did you resolve conflicts present in Object Repository?
What is RTM (require ment tracebulity marix) fromate?
What is the extension of qtp local repository?
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
Explain the check points in quicktest professional (qtp)?
Give me some real time point of way where exactly we can conduct audits?
What are the different types of action?
how to find that tools work well with your existing system?
Which functionalities of QTP used in banking project?
Subj: realtime example of Database check point, Can any one please detail on how the Database check point is utilized/implemented in a real time project. I already know how to make one by creating DSN/ODBC and writing the required query manually and other steps...I wanted the actual concept of implementation...couple of live examples will be highly appreciated. Thank you in advance
What is the parameterization?
Both static and dynamic arrays are handled by the vb script. Is it true?