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 |
Could any one explain about the nested actions in QTP? This question is asked by Qualitree and CA
3 Answers CA, Qualtree Solutions,
How to Synchronize the Browser at Field level? For example if you put Browser.sync(), it will wait upto for that Browser sync only. But It should wait upto total Browser get uploaded with all fields. Note : We don't know Which fields will come in that Browser. Means without knowing field names.
How to check the value for variables during run time. Pls anybody can give the answer.. Thanks in advance...
After coming to know that QTP could not identify non-standard objects, we set those non-standard objects as virtual objects using Virtual object wizard. But how can we identify that qtp could not identify non-standard objects?
Can I change properties of a test object?
Hai Friends this is Rajesh , Is there any Site or Blog that Video tutorials of Qtp that can be free downloadable to Pc. Friends if any body know that site or blog please send me because i'm really in need for that because i cannot affordMoney in learning Course in Institutes due to Financial Problem . So please Forward that Site or Blog which provides Downloadable Video Tutorials in Free to PC , As My Friend is having PC thru that I'm planning to learn. So Kindly help me Friends if you are aware of that Site/Blog
regular expression
QTP is identifying all windows application objects(i.e. winbutton,winconbobox,etc) as winobjects.How to handle this? Is there any way to add our own properties to identify objects?
What is the use of text output value in quicktest professional?
How to check and display a particular word from a paragraph?
I have application it is one digital clock with all minutes and seconds. you have to identify the time to verify weather the time displayed is correct time or not? How do you automate this scenario?
what is difference between application testing and product testing?