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.

Answers were Sorted based on User's Feedback



How to export data in excelsheet to qtp without using datatable...

Answer / 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

How to export data in excelsheet to qtp without using datatable...

Answer / madhavi

We can create an excel object i qtp and then export or
import data.

Is This Answer Correct ?    4 Yes 2 No

How to export data in excelsheet to qtp without using datatable...

Answer / tvs ramakrishna chowdary

sorry ur queston is not proper again post question properly

then i can give answer

Is This Answer Correct ?    0 Yes 2 No

How to export data in excelsheet to qtp without using datatable...

Answer / tvsrkc

we can import data from excel sheet but not export syntax
as follows

datatable.import("d:\sampls.xls")

we can export data from qtp to excel file by using
following syntax

datatable.export("path")

in both situations export/import runtime datatable takes
place

Is This Answer Correct ?    1 Yes 5 No

Post New Answer

More QTP Interview Questions

What is the difference between systemUtil and invoke method..?

5 Answers  


If I change the object name in one action will it be updated in all the actions? Or not?

0 Answers  


Hello friends can anybody tell me about the architecture of QTP with diagram of it.this architecture is same for any domain like ERP/Banking/CRM/Healthcare or it's different then please tell me.thanks

4 Answers   Fidelity,


How do we run a test from the 3rd row of the datatable in QTP? Leaving the first two rows we need to test AUT from 3rd row to n'th row.

3 Answers   Virtusa,


Explain features of the latest version of qtp/ uft 12.1?

0 Answers  


in QTP,how to write a descriptive program for "yahoo" or "gmail" Login page

1 Answers  


This is Ajay i have few douts if anybody know pls give me reply. 1. i have opend 2 gmails i am working with 1 gmail i want to close other gmail by usig script. 2.i have 10 links in a page all of them have same properties& names i want to click on 5link by using script. 3.i have one combobox in that i want to see all the citynames in the combobox and i have to check weather hyderabad is present or not. 4. size of objectrepository. 5.what r problems we get during writing the script. 6.is it possible to compare to excel sheets in qtp if possible wht is the script. 7.example for lowlevelrecording

3 Answers   Symantic Space,


How many types of Check Point in QTP

2 Answers   R Systems,


hi guys, pls tell me for testing institution training hub, hitech city is best or not?

0 Answers  


Explain about the Test Fusion Report of QTP?

1 Answers  


In my application there is a billing thru credit card. how to validate the credit card details(min balance,credit card no,card holder name).if these details are valid then only that booking will be done.how to validate these details thru automation or manual?

1 Answers  


What is keyword driven framework, what is "key" in It.

2 Answers   IBM,


Categories