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

Answer Posted / varun bisaria

Datatable.Import "...XLS file name..."

DataTable.ImportSheet(FileName, SheetSource, SheetDest)
DataTable.ImportSheet "C:
ame.xls" ,1 ,"name"

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is meant by function library?Public and private functions in function library? if private functions are applicable for only for the particular test means then y we have to add those to function library?

1369


What is the difference in testing a client-server application and a web application?

579


How will you declare a variable in qtp?

546


how can we compare descriptive programing with a regular expression

1915


Where should i find checkpoint and virtual objects's Object properties and values in the QTP 9.2 Means where checkpoints or virtual objects related data will store If i want to get the runtime object properties how can i use Getroproperties on Checkpoints

1451






What is checking bitmaps?

548


What is action? How many types of actions are there in qtp?

609


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

1279


Hi,Sudhanandareddy plz forword framework and ppts for QTP to me. This is my mail id: ranjith_99reddy@yahoo.co.in (your contact number also)

1730


What is test object model in quicktest professional?

617


Hoe can we do retesting using functions please give the code for it using login page

1553


What is the difference between shared and local object repository?

613


Hi How to retrieve data from web element line by line?

1571


what is clean sweep?

1877


How do Parameterization and Data-Driving relate to each other in QTP?

552