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

Discuss quicktest professional (qtp) environment?

0 Answers  


Synchronization methods?

8 Answers   Ordain Solutions,


hi in real time who will execute the qtp test scripts? my faculty said, in a companty automation testers are written the test scripts and manual testers are execute the test scripts...IS IT RIGHT OR NOT?

2 Answers  


what is smart identification?

1 Answers  


1.IF SOME OBJECT IN APPLICATION IS NOT IDENTIFIED BY QTP? HOW WILL YOU OVERCOME THIS? 2. WHEN AND WHYDO U GO FOR DESCRIPTIVE PROGRAMMING? 3. WHAT IS THE DIFFERENCE BETWEEN VB AND VBA? 4.WHAT ARE THE REGULAR EXPRESSIONS YOU USED? 5.IF ANY REQUIREMENT IS ADDED IN YOUR PROJECT, HOW WILL YOU PROCEED TO DERIVE THE TEST CASES AND HOW WILL YOU PERFORM AUTOMATION FOR IT?

2 Answers   RBS,






I have 14 itmes in a drop down that are associated with an account And these items change with different accounts I want to be able to define it by and index number or any other id so if I enter 2 in my Global excel sheet it selects the 2nd item from the drop down - is this possible?

5 Answers   Rogers,


What is action?

0 Answers  


Hi, can explain the draw back of manual testing.plz send me the answer to my mail id deepthip1985@gmail.com

0 Answers  


hi testers,one script has three actions , at the of running three actions are running , how to set run only perticular action and what is the use of split the action? when it will be useful?

3 Answers   Syntel,


I need to obtain the parent of an object programatically, so if I have: winButton("aButton") I need to obtain the parent part: window("Window1").Dialog("Dialog1") so I can programatically create a string of the full name of the object to call it with an execute statement in QTP I would like to use something like: part[1] = "window(""Window1"")" part[2] = "dialog(""Dialog1"")" so I can do: exeLine = part[1]&"."&part[2]&"."&"winButton(""aButton"")" Execute exeLine Apart from keeping a record of the window/dialog hierarchy is there a parent or path function/ command Thanks Adrian

0 Answers   Accenture,


can test automation improve test effectiveness?

0 Answers  


Can the user toggle between using Local OR and shared OR for the same action?

0 Answers  


Categories