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

Hello everyone! I am just writing a small test for a windows application. I have a problem with a text output value. The value i am trying to catch is presented in a scrollable textbox. When the text is too long, only a portion of it gets captured. Do you have any experience with this?

0 Answers   HSBC, T Mobile,


How to Test the mainframe application?

0 Answers   Unisys,


How can we fill data in a text box without recording using object spy. Can you please provide the steps...

1 Answers   Hotel Jobs, TCS,


How many types of parameters are available in quicktest professional (qtp)?

0 Answers  


What is log file?How to write log file code?

2 Answers   Apps Lab, Value Labs,






How can we extract data like "Details","Result","Time" from the 'Run Error' result generated in QTP after run time errors are generated during a run & import the details etc...into excel sheet

0 Answers  


can we run the scripts of qtp 8.2 in the qtp7.0?

1 Answers  


Can any body tell me what is the method to connect the remote desk top throw QTP 9.2 version?

1 Answers  


Please any on explain usage of "on error resume next","On error goto 0" with sample code....Thankyou......... when a tester is asked to execute 100 scripts in a short time..(the server will be down in another 10 min)..how he has to run those scripts?

2 Answers   Datamatics,


c language is thre but what is the purpose of c++, java is there but what is the purpose of Advanced java ....why these are all versions are coming...whta is the problem?

2 Answers   Accenture,


what is throw object ?

1 Answers  


hi this is srinivasa(from blr) i complited my B.tech(e.c.e) in 2007 im searching job in s/w testing but idont have freshers resume for s/w testing please send some s/w testing resume for me(fresfers resumes only) advns thnks you

2 Answers  


Categories