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



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

Answer / ramyab.mca@gmail.com

Hai....

Import data from a ".xls" file to Data table during Runtime:

1.Datatable.Import "...XLS file name..."
2.DataTable.ImportSheet(FileName, SheetSource, SheetDest)
3.DataTable.ImportSheet "C:\name.xls" ,1 ,"name"

K,Byeeee...
Thanks & Regards
B.Ramyasri

Is This Answer Correct ?    2 Yes 0 No

Post New Answer

More QTP Interview Questions

Can we create test script with out Step Generator?

4 Answers  


How u prepare Test result summary in QTp?

4 Answers   CGI,


what is objectidentification?

2 Answers  


What is meant by virtual obj and Y do v need virtual obj configuration.

4 Answers  


I Selected for TCS-Chennai(Contract to hire) position plz suggest me whether i have to join or not

2 Answers   TCS,


What are the views available in quicktest professional?

0 Answers  


how to get childobject from .net application. i tried but its showing child object count zero. but window has child objects.the following script i written... pls help me how to get. set parent=SwfWindow("winodw name") CheckObjectDescription parent, SwfButton Public Function CheckObjectDescription(parent, oDesc) Set oDesc = Description.Create() oDesc("micClass:").Value ="Swfbutton" Set children = parent.ChildObjects(oDesc) cntObj=children.count msgbox(cntObj) End function

1 Answers  


What is qtpro? What is quick test pro? What is a quick test professional?

0 Answers  


I am struggling to understand QTP more from descriptive programming point of view. Is it easy to learn good QTP in South india by good faculty than north india? I found a great lack of institution in here. can you suggest me better instituion. I am holding two years of experience in same company, is there possibility in south india for me?

1 Answers  


how we can take data in the username field text box into variable in web application explain with example and give all functions to get data into variables

6 Answers   iton, TATA,


RECENTLY I PLACED IN QTP..HOW TO IMPROVE VB SCRIPTS KNOWLEDGE? IAM STRUGGING TO WRITE THE AUTOMATION SCRIPTS? ANY BODY TELL HOW TO IMPROVE QTP SCRIPT SKILLS?

0 Answers  


how to find that tools work well with your existing system?

0 Answers  


Categories