How to retrieve particular cell data in excel sheet ?without importing method.
- 3 Answers
- 4858 Views
- I also Faced
- E-Mail Answers
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 |
What are the environment variables?
My project title is "DRUG Audition and research management" it comes which domain?
How many ways we can parameterize data in QTP?
Can any suggest me what is exposure testing?
What is the difference between shared and local object repository?
what is the exact testing process in qtp plz explin ?
What is the Diff between Image check-point and Bit map Check point?
Does QTP record on Objects created on XWindows Environment?
X flies from Hyd to bangalore using different methods of transportation. write the test scenarios and test cases for this?
On what basis we select test cases to automate?
what is test scheduling?
i need the word "good morning" to be displayed by default whenver we click upon the blank test while opening the qtp. Could you please answer...
WinRunner 
