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.

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how to test Web application using QTP software

1571


what are the critical test cases in crm? tell me atleast 5 critical test cases? what are the critical bug u find out while testing crm domain?

2740


Explain step generator in qtp?

651


hi to all, i need a code.. in flight application 1.i need to login first then i need to insert 3 new orders... 2.i have to log out 3.i have to login again with different user 4.need to insert 2 new orders 5.then need to log out 6.then again login with different user 7.3 new orders create and log out 8.but we hv to do this using data table and actions please help me

1761


How many types of Automation frameworks are there in UFT? Describe them.

560






How can you write the scripts that operate on different objects depending on run-time information?

2122


What are some test assets and related extensions of qtp?

557


What kinds of security (firewalls, encryptions, passwords, etc.) will be required and what is it expected to do? How can it be tested?

643


Does QTP10 supports Windows 7OS +IE 9 combination? Which is the preffered combination ,Plz let me know?

2981


Is there anyway to automatically update the Datasource name in Database Checkpoints object when we migrate tests to a new release?

3275


I want to capture data(using keyword) from msdos application using QTP?... Below is little work i could do on it... /* Set app=CreateObject("Wscript.shell") SystemUtil.run ("C:\Users\Agent\Desktop\pumpsim\PUMPSIM.EXE") Window(“PUMPSIM.EXE”).Activate wait(3) app.sendkeys "N" */ Thanks in advance...!!!

1439


Can testing be done on the production system, or will a separate test system be required? How are browser caching, variations in browser option settings, dial-up connection variabilities, and real-world internet 'traffic congestion' problems to be accounted for in testing?

621


Explain the N-tire structure(process) for Funds Transfer ( means give N ways to funds Transfer in an Application)

1638


any body can you help me what is the script to automate an comand promt

1980


How to use the object spy in quicktest professional (qtp) 8.0 version?

515