How can we open an Excel sheet through the script
Answer Posted / tvsramakrishnachowdary
Hi Chandra sekhar...
Every time ur approach is abt recording...pls try to avoid
that..it will creates u prob in the real time..ok...
follow following code...
-----------------------------
set xa=createobject("excel.application")
set xb=xa.workbooks.open("d:\sample.xls")
set xs=worksheets("sheet1")
val=xs.cells(1,1).value
msgbox val
NOTE:here (1,1)--->1st row,1st column
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
what is the mail use of frame work(with detail). architecture for keyword driven frame work
Hi All , How can we decicde for pariticular frame(DataDriven or Keword Driven)in Project? Thanks Balaji
Explain the check points in quicktest professional (qtp)?
What is ‘object spy’ and what is the function of object spy in qtp?
what is the difference between rational rose and QTP? WHICH TOOL IS BETTER TO LEARN? PLEASE SEND ME AT sana_50218@yahoo.com sandeep@epuratech.com
How can we conduct U-I Testing by using QTP??????
how to fetch the values from grid? & qtp recogniges that grid as a webelement? what u do?
What are the differences between quicktest professional and winrunner?
I am in .Net development for past 3.5 years and want to enter in to automated testing and learn QTP. For this I need some good tutorial for beginners. I will be really greatful if any one has and they can send it to me on this address- ruchidureja@gmail.com
How many add-ins comes by default with quicktest professional (qtp)?
How you calling actions in qtp?
Can we use index on view?
Hi,All How to create a link in excel sheet using qtp
An action has both shared and local or associated to it and both have the same object in them. In the test which one will be considered?
can any body plz help by sending the qtp docs and qtp ppt's? this is my mail id:murali.padeti@gmail.com