Other than using import sheet statement for importing the
data from excel sheet, is there any other method that can
be used?

Answers were Sorted based on User's Feedback



Other than using import sheet statement for importing the data from excel sheet, is there any othe..

Answer / santhosh

Without using Import sheet statement as (VB script),we can
use of Datatable.
Rightclick on the datatable of QTP tool,we will get an
option called File->Import File From
From there you select the path of excel sheet,then start
parameterizing now from the datatable without going for
Excel sheet.

Is This Answer Correct ?    1 Yes 0 No

Other than using import sheet statement for importing the data from excel sheet, is there any othe..

Answer / shann

like if ur fetching data frm data base

for each fields in recordset.fielda.count
datatable.globalsheet.Addparameters fielda.name
next

datatable.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More QTP Interview Questions

What is the main difference between QTP 8.0& QTP 9.2.And what r the features and benefits of QTP.

1 Answers   HCL,


setroproperty and getroproperty difference

5 Answers   Ordain Solutions,


what is framework in QTP? any one give me answer

4 Answers   Wipro,


can anyone answer this question ........in the DICTIONARY OBJECT....i created the dictionary object in reserved object ok....here i have some sets of values ...now i want to retrieve the item i done too ok.......here my question is now i saved the test and close the qtp tool ,again i opened now i retrieve the same item in the dictionary is it possible ????. friends when i try to do this i am getting empty message box i mean no value will be retrieved ......ans me any one plz...

1 Answers   FSS,


Hi All, I need 5 yrs exp manual and automation testing using QTP sample resume. is there any body having please send me my mail id is bjr@aol.in Tahnks in Advance

0 Answers  






There are 10 rows in the datatable. How can we fetch 2 rows and then skip 3rd row. After that, pick 4th & 5th row and skip 6th row. Please share code

0 Answers  


How we can merge the object repositories?say if we have 2 or 3 object repositories then how we can merge them?Is there any option in QTP to merge the object repositories?

2 Answers  


What is meant by virtual obj and Y do v need virtual obj configuration.

4 Answers  


can any one tell me the script to click on a button in the wintoolbar.

1 Answers  


Explain about the test fusion report of quicktest professional (qtp)?

0 Answers  


I have a WebEdit Object.It is added in object repository.It has two properties Name and Index.In the next release the Name Property is same but the index property is changed.when i run the script will the script Pass or Fail

9 Answers   ADP,


Can we do qtp testing without creating objects in Dbject repository? can we do it completely writing code i.e in expert view only. Are there any books for this?

7 Answers   Accenture,


Categories