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
how to test Web application using QTP software
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?
Explain step generator in qtp?
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
How many types of Automation frameworks are there in UFT? Describe them.
How can you write the scripts that operate on different objects depending on run-time information?
What are some test assets and related extensions of qtp?
What kinds of security (firewalls, encryptions, passwords, etc.) will be required and what is it expected to do? How can it be tested?
Does QTP10 supports Windows 7OS +IE 9 combination? Which is the preffered combination ,Plz let me know?
Is there anyway to automatically update the Datasource name in Database Checkpoints object when we migrate tests to a new release?
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...!!!
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?
Explain the N-tire structure(process) for Funds Transfer ( means give N ways to funds Transfer in an Application)
any body can you help me what is the script to automate an comand promt
How to use the object spy in quicktest professional (qtp) 8.0 version?