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 will be happen if i load object repository at run time, but it has already associated.

0 Answers   NTT Data,


Plze let me know how you can validate in the QTP that printed documents is correctly printed or not ie how we can do the validation that all the records or text are printed successfully in the printed document as per the application format requuired.

4 Answers   MBT,


IN EXCEL SHEET OF qtp SUPPOSE I ENTERED 10 NUMBERS RANDOMLY I HAVE TO GET TOTAL OF TEN NUMBERS IN THE 11 COLUMN USING qtp GIVE CODE TO IT USING qtp

2 Answers  


How open an excel sheet in QTP(not a run time )?

4 Answers   Tech Mahindra,


hi guys, could you please prepare script for given format ? 1,1,2,3,5,8,13,21,...etc use vbscript for this...?

2 Answers   Value Labs,


I am a new tester that needs to create an automatic script involving security questions. On a webpage I need to select a security question(which are random) from a drop down menu, and then input the answer as the last word from the security question. I have the script set-up to automatically select the first security question from the drop down. The problem I am having is trying to insert the security answer. How do I insert the security answer based on the selection from the security question?

0 Answers  


unable to get item from the combobox using descriptive programing. can any one give me the peice of code to schedule the booking from one place to another using DESCRIPTIVE PROGRAMING.

1 Answers  


How to use QTP for Regration testing, plz tell as with short Example of login window? plz tell as....

2 Answers  


Use of Multiple Actions in QTP?

3 Answers  


How can we count the no of rows are available in a data table ?

9 Answers   Kanbay,


Can we call a parameter from an action to other action?

4 Answers  


write code to read and write data from file?

1 Answers   IBM,


Categories