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   interview questions urls   External Links  Contact Us     Login  |  Sign Up                      
tip       Ask Questions on ANYTHING, that arise in your Daily Life at     FORUM9.COM
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
Hi All,

I'm Akshaya here, could anybody please help me regarding 
how to import the excel sheet to run time datatable. But 
Pl. keep it in your knowledge is that excel sheet is opened.

Thanks,

Akshaya Madali
9823213538
 Question Submitted By :: Akshayainbox
I also faced this Question!!     Rank Answer Posted By  
 
  Re: Hi All, I'm Akshaya here, could anybody please help me regarding how to import the excel sheet to run time datatable. But Pl. keep it in your knowledge is that excel sheet is opened. Thanks, Akshaya Madali 9823213538
Answer
# 1
Hi Akshaya,

This is Thirupathi,iam working on QTP regarding your 
question iam sending you answer
If any questions on QTP Call me on my mobile NO. 9922019467

DataTable.ImportSheet "C:\Test1.XLs" 1,1

1- is Destination Sheet ID( to Data Table)
1- is Source sheet id ( from Excel Sheet)

Regards,
Thirupathi Ganguly
 
Is This Answer Correct ?    0 Yes 0 No
Thirupathi Ganguly
 
  Re: Hi All, I'm Akshaya here, could anybody please help me regarding how to import the excel sheet to run time datatable. But Pl. keep it in your knowledge is that excel sheet is opened. Thanks, Akshaya Madali 9823213538
Answer
# 2
datatable.import "D:\Document and setting\test1.xls"
 
Is This Answer Correct ?    0 Yes 0 No
Suresh
 
 
 
  Re: Hi All, I'm Akshaya here, could anybody please help me regarding how to import the excel sheet to run time datatable. But Pl. keep it in your knowledge is that excel sheet is opened. Thanks, Akshaya Madali 9823213538
Answer
# 3
FOR IMPORTING PARTICULAR SHEET FROM THE EXCEL BOOK.
--------------------------------------------------
Datatable.importsheet "D:\test1.xls",1,1

FOR IMPORTING WHOLE EXCEL BOOK(DEFAULT 3 SHEETS) 
------------------------------------------------
Datatable.import "D:\test1.xls"
 
Is This Answer Correct ?    0 Yes 0 No
Siraj
 

 
 
 
Other QTP Interview Questions
 
  Question Asked @ Answers
 
where we are going to write the descriptive programming.for example we are invoking qtp application where we are going to write that code  3
How to get data from excel sheet to the script? write the script. Liquid-Hub4
How to Set the Global Sync Timeouts in QTP?  1
Wht is Smart Identification Mechanisam in QTP..Actually when do we this Technology means during Recording or running ....how is technology works. Anybody can expalin this .....Thanks in advacne Siemens4
what is the purpose of .vbs file? HCL2
What is the Difference between Environment variable and Globle variable,.. anybody can give me answer..Thanks in advance... IBM1
how do we add a new sheet to data table in QTP? Wipro5
How to compare the two strings?  1
How can we encrypt the username using recording mode in login window? There is 2 encrypted types what are it TCS1
can u please explain what r the challenges u faced in ur automation testing Genpact1
In smart identification, explain about 1. Base filter properties 2. optional filter properties with examples? TCS1
What are default add-ins in qtp? Semantic-Space4
How can i select multiple values from drop down list using vb script in qtp? and wt is the script for clicking msg box box automatically with a specific time. Thanks in advance...Kalyani. CSC2
Does QTP provides any tools for parametarization? BirlaSoft2
How many actions we can create with in a test?  2
how can i impliment error handling in QTP? Ordain-Solutions4
wt is the difference between global and action excel database in qtp?for example one action is calling another action the second action is using action excell sheet?if it is using global sheet what makes the difference? Datamatics1
Give some brief idea about a) Active x check b) Alt property check c) Applet object check d) Frame object check e) Multimedia links check f) Server side image check g) Table object check CTS1
Tel me what was the automation testing process you followed?  2
what is a file system object in QTP  3
 
For more QTP Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

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