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

Have you done batch testing in qtp? If yes how you are doing?

513


Why do we use "Text checkpoint" If we can make use of it in "standard checkpoint" ?

1490


How do you create regression test packs?

614


How many ways we can parameterize data in quicktest professional (qtp)?

589


can any body tell me how i create a simple script and apply output value on it .pls send me a step by step process

1289






What is file database?

1696


in a web page hoe to check the dynamic links that rechabging with out using regular expressions

1785


How u will do versioning in QTP?

1462


How to capture a window in QTP?

1531


what you mean by artifact,milestone...

1503


What are the properties you would use for identifying a browser and page when using descriptive programming?

637


If u r using library files (Instead of Check Points) , How do u do bitmap check ?

1459


What are parameterizing tests?

553


Is text area check point supports for web applications?

537


How you can delete excel file in qtp?

599