ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
tip   SiteMap shows list of All Categories in this site.
Google
 
Categories  >>  Software  >>  Testing  >>  Automation Testing  >>  QTP
 
 


 

 
 WinRunner interview questions  WinRunner Interview Questions
 Load Runner interview questions  Load Runner Interview Questions
 QTP interview questions  QTP Interview Questions
 Test Director interview questions  Test Director Interview Questions
 Rational TestSuite interview questions  Rational TestSuite Interview Questions
 Silk Test interview questions  Silk Test Interview Questions
 Automation Testing AllOther interview questions  Automation Testing AllOther Interview Questions
Question
How to Import data from a ".xls" file to Data table

during Runtime.
 Question Submitted By :: Sreeprasad
I also faced this Question!!     Rank Answer Posted By  
 
  Re: How to Import data from a ".xls" file to Data table during Runtime.
Answer
# 1
DataTable.Import("path of the file")

DataTable.ImportSheet("filepath","sheetsource","sheetDest")

Sheetsource:index or name of the sheet in the file which u

want to import. index begins vth 1.

SheetDest: index or name of the sheet in the datatable

which u want to replace vth Sheetsource.Index begins vth 1.

ex:

Datatable.importsheet("c:\name.xls",1,"name")
 
Is This Answer Correct ?    0 Yes 0 No
Sreeprasad
 

 
 
 
Other QTP Interview Questions
 
  Question Asked @ Answers
 
When and why do you use "OPTION EXPLICIT" in VB Script. Is there any online help or something to learn the script for Beginners?  5
How to get data line by line from web element  1
Hi! Using Descriptive Programming How do we get Parent object for an object. Say, i want to get a parent object for a "Link" in a web page. thanks  3
What is Object Spy in QTP? vsworx10
WHO TAKE DECISION TO RELEASE THE BUILD IGT1
whenever a scenario is recorded ever, it creates a object repository automatically (‘per action’ /local ). we do not need to make them individually…then why we need a shared object repository. How it will be practically utilized ?? your input will be highly appreciated..  5
After creating testcases, how do you start testing in QTP? what methodology will follow? American-Well6
Can you import and export data from XLS and how?  4
What is your role and responsibilities in QTP with your current organization?  1
Give answer with example what is orthogonal array testing technique? CTS1
How can I deploye a 'QTP Runtime environment only' Indexis1
Once we get the Test Result from QTP.,I Have to convert into Excel file format..Is it possible..Can any gudie me regarding this... For Example : Total Test Case is : XXXXX Test Case passed : XXX Test Case Failed : XXX -------- Total XXXXXX ---------  6
how to capture tool tip in QTP and which check point is needed Syntel2
Hi any body can tell me the in detaled information about Description.Create() thanks in advance  2
is it possible to map an image as standard Object or u've to treat as virtual? how to map an Dynamic image into standard object?  1
what is key word driven frame work how to use keyword driven frame in QTP in a project AppLabs1
WHICH PROCESS U FOLLOW IN COMPANY IGT1
HI ALL I AM WORKING AS A AUTOMATION ENGINEER FROM PAST 2 MONTHS IN QTP,MY QUESTION IS IF I OPEN THE BROWSER FIRST & THEN THE QTP LATER MY OBJECT SPY WILL NOT WORK,Y IT IS SO..IF U HAVE THE ANSWER PLZ MAIL ME AT AKSHAR.MYSORE@GMAIL.COM Infosys4
can we install qtp in windows vista  1
What is difference b/w AOM,DOM,COM Have u ever is used ny of the models.If so why? GE1
 
For more QTP Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com