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 to get data from excel sheet to the script? write the
script.

Answer Posted / jyothi

Set a= Createobject("Excel.Application
Set b = a.workbooks.open"D:\Keyword\Test Data\data.xls"
Set c = b.Worksheets("sheet name")


Then retrieve the data like

set x= c.cells(1,1).value

Is This Answer Correct ?    8 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is the difference betn QTP 8.0 AND PREVIOUS VERSION

2436


What is the use of an object spy tool in qtp?

1004


Explain about datafile/verification of date file when file is not available in local system?

2716


What are the check points can be inserted without recording?

1057


What is an optional step in qtp ?

1169


Explain the concept of object repository and how QTP recognizes objects?

1028


What is quicktest professional window?

977


What are metrics and matrix?

1783


How you can find length of array in qtp?

999


How does qtp recognize objects in aut?

1020


How QTP identify the system time that's changes every seconds?

1037


How to write business scripts using object repository with different scenarios

1902


What is keyword driven framework?

1069


am not having intrest in coding lang like c c++ java etc can i choose Testing tools as my carrier and please suggest me which tool is good (suitable for me)

1701


Plz Explain AUTOMATION REFERENCE MODEL?

2197