Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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


Please Help Members By Posting Answers For Below Questions

How will you test a keyboard?

1092


What is test object model in quicktest professional (qtp)?

986


"What are the common constrains that we need to consider when we prepare testcases for ASP application". Thanks in Advance...

1990


What is quicktest professional?

1022


How to execute a winrunner script in quicktest professional (qtp)?

953


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.

2117


Connect to QC using AOM.

1672


How do you convert manual test cases to automated test cases?

1100


How to get popup error message.

1553


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

6202


Please guide me release notes of Automation once scripts are completed

1891


What is the XML file architecture ?

1990


i have doubt suppose iam purly working in QTP, when i will work on sql and performence testing? pls any one clarify doubt?

1984


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.

1854


What are the differences between quicktest professional (qtp) and winrunner?

1049