Hi,
When iam trying to import sheet to the QTP Global data
table at the run time using the Importsheet method.It is
able to import the sheet but no data is present after the
import due to which the test is failing.Could anyone
suggest what should be done.
When I open the actual excel sheet data is present and is
not corrupted.

Answers were Sorted based on User's Feedback



Hi, When iam trying to import sheet to the QTP Global data table at the run time using the Impor..

Answer / venkat

hi first u open excel file on your desktop,fill the data

datatable.addsheet"venkat"
datatable.importsheet"give here your desktop excel sheet
path",1,3

this is 1 is global sheet and 3 is new excel sheet, try it
on your qtp ok

thanks & regards
venkat

Is This Answer Correct ?    2 Yes 1 No

Hi, When iam trying to import sheet to the QTP Global data table at the run time using the Impor..

Answer / esu

chick excel workbook extention for".xls". other then .xls we
cann't.

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More QTP Interview Questions

Hi guys can any plz help me how to send fax in sample Flight Appication

1 Answers  


Can i get a simple example exercise for update run mode for sample flight application......... In qtp when i try to run the test in update mode.. Auotmation> update option is disabled............ Pls let me know ................. Thanks in advance.....

3 Answers  


How to find Operating system information using QTP script?

0 Answers  


I want different types of discriptive programming statments coded for different types of web-objects?Give syntax and example?

2 Answers  


What is the standard timing delay for web based application in qtp?

0 Answers  






where do you store the test result?

2 Answers   HCL,


Hi,All How to create a link in excel sheet using qtp

0 Answers  


How to convert non-reusable action into reusable action in QTP?(i know by default QTP will take it as a non-reuable action )(Chandana) plz urgent?

4 Answers   Wipro,


How to use conditional loops in qtp ?

0 Answers  


Suppose if a functionalityis not mensioned in requirement document and but its present in application. will it be consider as a bug and viceversa?

2 Answers  


How you automate testscripts one by one or moduelwise or all at once

2 Answers  


Which Databases supports for QTP?

2 Answers  


Categories