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

Answer Posted / srinivasulu

Dim Shet1' Add a new sheet
Data table.Addsheet "shet1"
'datatable.importsheet "file name","Source
sheet","destination sheet"
datatable.importsheet "file name","sheet 1","shet1"
'now we can check the run time data table

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain the difference between call to action and copy action?

523


How to analyzing the checpoint results?

522


What is the difference between qtp and selenium?

549


Hello Everyone, Please provide me the practical example of business component concept of QTP.Like how to create business component,how to connect the quality center etc.... Thanks in advance, Gaytri

1407


What are the different types of checkpoints?

588






What is QTP testing process?

629


Hi there, I've installed a trial version of QTP to see if it works with my product but I cant automate selecting windows from a tree view? Can anyone give me any pointers? Many Thanks

1414


whare exactly we have to use functions and sub routain

1846


Is any limitation to xml checkpoints?

563


Why script error occur in between recording in qtp?

1769


whenever U using QTP,Test Director, Why we using separate Bug tracking tool?

1568


hi i have completed my b.tech in cse stream. now i am working in an organisation in testing department. i want do sap course but i dnt know which module will boost my career can anyone suggest me which is good for my career

1931


if mandatory and Assitive propertys are shows same how will u write skript in QTP window

1628


How to add synchronisation points in qtp?

580


What is action split and the purpose of using this in qtp?

537