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 'sleep' in sync point?

631


How to find array size in qtp?

587


What are the recording modes in qtp?

588


Is it possible to use two instances of UFT on the same machine? If not why?

607


What are the different attribute used with regular expression?

537






Give the syntax to import/export xls into qtp.

589


what type of run time errors you get while you ar edoing rpg program?

1515


what difference between runtime object and text object and what property they have. whether they have same properties or different properties.

1711


What is the registration process and examination fees?

559


Hi we are using QTP9.0 for Seibel Application and this seibel application will give you a popup messagebox which is of web , so qtp takes 3 mins to recognize the messagebox and to click on it , we have more number of messageboxes like this . please suggest me some solution

1671


What is keyword driven framework?

622


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

528


how to post xml data from QTP scripts to any application?

1506


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

1517


What is recovery scenario in qtp?

588