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
How will you test a keyboard?
What is test object model in quicktest professional (qtp)?
"What are the common constrains that we need to consider when we prepare testcases for ASP application". Thanks in Advance...
What is quicktest professional?
How to execute a winrunner script in quicktest professional (qtp)?
When QTP object wait time is 10 seconds, and in test script wait time is 5 seconds and in function library wait time is 2 seconds how much time does the wait occur? or which is given priority.
Connect to QC using AOM.
How do you convert manual test cases to automated test cases?
How to get popup error message.
QTP 10.0 is not identifying web objects for IE 8.it is identifying like winObject.I installed HP patch QTPWEB_00037.Still getting issue
Please guide me release notes of Automation once scripts are completed
What is the XML file architecture ?
i have doubt suppose iam purly working in QTP, when i will work on sql and performence testing? pls any one clarify doubt?
hai, i completed my b.tech in 2010 with 62.3%. i having knowledge on manual testing and Qtp. i want Relavent experience in testing.watever may be d salary i dont bother..I just want to gain knowledge. i dont have good communication skills.
What are the differences between quicktest professional (qtp) and winrunner?