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 export data in excelsheet to qtp without using
datatable.

Answer Posted / rajesh

Set objInputDataxlsFile=createobject("Excel.Application")
objInputDataxlsFile.workbooks.open <File_name_Path>,true,true
Set
currentworksheet=objInputDataxlsFile.Activeworkbook.Worksheets(1)
UserID = currentworksheet.cells(1,3).value
Password1=currentworksheet.cells(2,3).value
Status = fnLogin 'Call to login function
currentworksheet.cells(4,3).value= Status

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how to evalute defects in QTP script?

1937


How to Upgrade or support firefox 2.0 version on QTP 9.0? I have installed QTP 9.0 and installed firefox 2.0. But in REcord and Run Settings, it shows firefox 1.5 in Web tab for browser selection.

2225


Can any body please tell me the steps of keyword driven frame work in qtp. My mail is saswat445@gmail.com please send some materials on keyword driven testing in qtp. thanks a lot...

2185


What is test object?

1083


On what document base Descriptive programming is written if build is not yet ready ?

1350


Explain xml checkpoints.

1059


Could any one tell me "How can i recognize my cursor position using QTP 9.2" Give me a scripts for this

2464


Explain the views in the QTP GUI?

997


Does QTP10 supports Windows 7OS +IE 9 combination? Which is the preffered combination ,Plz let me know?

3367


what is run action?

1862


If there is a change in the object type eg: A button is changed as link, 1. How to edit that in the shared object repository. 2.What options are available to edit the object within shared object repository other than copy from loca; 3.What would be the effect of the change in Coded Scripts within QTP and Functions stored in .vbs file which are loaded and used in QTP

1687


How to use actions in qtp ?

993


In qtp, how you can remove the spaces from string?

920


HOw to add the recovery file at runtime to the test file .

2107


what is clean sweep?

1908