How to retrieve particular cell data in excel sheet ?without importing method.
Answers were Sorted based on User's Feedback
Answer / uday
The Question is to retrieve a cell value from Excel sheet.
The method which does this is:
XLSheetObj.cells(rowno,colno).value
Is This Answer Correct ? | 1 Yes | 1 No |
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
Is This Answer Correct ? | 0 Yes | 0 No |
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
Is This Answer Correct ? | 2 Yes | 4 No |
How do u fetch data from a database ?
I'm having a problem to get the status(pass or fail) during runtime for every iteration ran, and must get the results stored to an excel sheet if possible.
Lets say,flipkart website...in search button we have entered category[i.e watches] it displays some items...question is how to test price displayed each product is correct or not through qtp
Is it possible to call win runner script in qtp?
we use a file extension .properties why is it used and where do we use it plz help me out with detailed explanation and navigation of how to use on the QTP 8.2?
Explain the parameter in qtp?
wht type of User defined functions or Java Releated functions do we write in VB scripting
What is checkpoints for quicktest professional (qtp)?
in data driven testing for performing operations which method is easy from manual test data,keyword view,or from database.and why?
How to build scripts that access data from external sources?
How do you export an output to a excel sheet? Ex: I get my answer by using Msgbox"..." &R. How do I displayed the result of the Msgbox (such as R) to an excel sheet? Please let me know.Thanks
How the objecs properties are identified?Tell me in Hierarchical order?