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

What is a recovery scenario?

781


What is TOM in QTP?

1993


How software automation specialist enter steps in the Expert View?

1873


How to find Operating system information using QTP script?

750


hi Friends ,willany body tell me what is the Scope for the automation Testing inht Future is their Or not And what is the Top Most Level in the testing section according the Pay scale

1785


When ‘option explicit’ keyword is used in qtp?

962


What is test object?

888


Explain more about the Test Fusion Report of QTP?

789


How do you capture tooltip using QTP?

809


what is clean sweep?

1716


What should we say if interviewer asks "What is ur project architecture?".......Can any one help me with clear information.?????????

1921


Any body have QTP 9.5 licence key. please provide me at madhukar_dec30@yahoo.co.in

1774


What environment does qtp run in?

786


How do you handle multiple banners(at the top the page, the banner is scrolling) in a web page(Dont take the name property(regular expression))

1864


How we can use the database checkpoint on a java web based application in which the database connectivity is done using JDBC->Pure Java type (in this type there is no need to create a DSN). At present in QTP we can fetch database values using checkpoint only through DSN. Is there any programming for this if we don't have DSN (ODBC)

2098