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
Anybody plz give, How do you test aframe in a web page? If page cotain text message or Images, tables?
Where we use data driver in qtp?
how do you parameterize search button from the website? the page is a single winobject and i have made a virtual object button of search button but search box can't be converted into a winedit and if we try to convert it into winedit the value we enter in a searchbox appears as numbers in the script so we arent able to parameterize.help!!!
How software automation specialist enter steps in the Expert View?
An action has both shared and local OR associated with it and both have the same object in them. In the test which one will be considered?
In the Hybrid framework, data can access the database, excel file, XML etc. Is it true?
Explain the Different types of QTP test assets and their extensions?
What is the synchronization point in qtp?
What is QTP scenario.
what is the frame work in J-meter?
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
how to test use the quality control .how to verify the image verification
Hi Friends, Im planning to do certifcation in mercury Automation Tool QTP.But I Didnt get any clear details regarding course syllabus, fees, where to approach, and which certification would be useful for the experienced testers? can any one send me the details?
How to interact tool & application build in QTP?
I would like to directly import XL file and work on that XL file directly in QTp script in that XL sheet need to allocate workbench,XL sheet and generate two bar graphs automatically how to do that? plz let me know any answers?