How to Import data from a ".xls" file to Data table during Run

Advertise your Business Here

Refer this Site

Login | Sign Up


	Do you have a collection of Interview Questions and interested to share with us!! Please send that collection to along with your userid / name. ThanQ

Categories >> Software >> Testing >> Automation Testing >> QTP

WinRunner Interview Questions

Load Runner Interview Questions

QTP Interview Questions

Test Director Interview Questions

Rational TestSuite Interview Questions

Silk Test 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

Question	Asked @	Answers
Other QTP Interview Questions


My project title is "DRUG Audition and research management" it comes which domain?		3
Can anybody give the script to addsheet, add column,add values under that column in the rows??	AZTEC	5
what are the drawbacks for record and payback in qtp		3
why the smart identification is not there in WinRunner	DigiTech	1
give the code to count child objects (Total) in the page		1
tell me the script for envirnment value parameeter with an example. which situation envirnment valu parameter is used	HCL	1
what is Business Process Testing plz explain?	iFlex	6
HI. Plz Clarifie my doubt,having 2+yrs experience in Testing , But My accedamics(Xth,INTER) are Less than 60%, But B.Tech 72%. It creats any problem , When i change to any MNC. plz tell me......... lot of friends told it's a problem, Some people says NO problem, What .............		3
what is difference between analog and low level recording	Intel	2
Test cases for Traffic Signals	AppLabs	4
Friends please let me know how id following possible in QTP: Can I apply conditional loop on a bitmap/image or any other checkpoint. Like if checkpoint passes then if or Else		2
Suppose I want to use Index value of "WinEdit" in my script .But it is showing None in "Ordinal identifier" value of Testobject Details in the Object Repository.How to enable Ordinal Identifiers to capture the Index value of that particular WinEdit. I have selected "index" and clicked "OK" from Tools-> Object Identification Again I added same WinEdit to the Object repository But I did not get Index value..Please any one help me.How to enable Ordinal indentifiers		1
What is the use of Regular expression?		4
How u send bugs to dev'lpment team all at once or one by one or waht is the process?	kenexa	2
why was automation used in the project?	Google	1
How can I test the unix shell in QTP	Persistent	1
if the excel sheet specified in script is not there,we get run time error how to handle the error ,please anybody explain me in detail	Quinnox	1
what is Compile Module in QTP? what exactly it contains Functions or Actions?		1
Hi, Plz give best Definition of Software Testing? Why we need Software Testing? and plz send 2+yrs experience Interview qutions (Manual,Qtp).		3
Waht is diff between SystemUtil.Run and invokeapplication		4

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