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

Where the text version of script file located in file system?

1 Answers  


how to retrieve the xml file data through qtp. can anybody send script for this..

3 Answers   Synechron,


is it possible to add sheets to excel at runtime

1 Answers  


What is the basic concept of quicktest professional (qtp)?

0 Answers  


What are advantages of test automation?

0 Answers  






what is compiled module?

1 Answers  


What are the Features & Benefits of Quick Test Pro ?

0 Answers   Crea,


what is the diffrence bw qtp architectute and qtp framework?

0 Answers  


Hi ,Can any one pleas explain how to test splash objects using QTP?

0 Answers   Value Labs,


How we can use the database checkpoint on a java web based application in which the database connectivity is done using JDBC->Pure Java type (in this type there is no need to create a DSN). At present in QTP we can fetch database values using checkpoint only through DSN. Is there any programming for this if we don't have DSN (ODBC)

0 Answers   LinkEdge,


HI, Anybody can explain Automation Test Framework...and wht do we do before start of Automation.....

5 Answers   Polaris, Siemens,


Difference between image checkpoint and bitmap checkpoint

2 Answers  


Categories