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

Answer Posted / sanhosh

The following example uses the ImportSheet method to import the first sheet of the name.xls table to the name sheet in the test's run-time Data Table. 
DataTable.ImportSheet "C:
ame.xls" ,1 ,"name"




How ever in runtime data table iam unable to get the sheet pls help me.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain actions in qtp ?

561


Can we run multiple QTP scripts one after the other without manual intervention? How?

600


Explain the types of properties that quick test learns while recording?

562


How did you resolve conflicts present in Object Repository?

1616


What is smart identification in QTP?

633






How does you pass optional arguments in qtp?

565


Hi, I am working on microsoft infopath forms..It is standalone form..(not dotnet or web.) . I am not able to indentify any objects in it.. I am currently using active accessibility in the macro for the same but its execution is too slow.. Kindly help in case you have better solution.

2410


What are the advantages of a Hybrid framework?

603


how can you do retesting (datadriven test) using notepad amd by using functions NOTE u should not use datatable methods

1382


How may types of defects identify application or your currently working application?pls give me answer..

1517


Explain features of the latest version of qtp/ uft 12.1?

606


Can you write a script to check if the folder exists or not?

517


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

564


How to handle Java tree in QTP?

748


Explain the features of quick test pro(qtp)?

579