in qtp we ve datatable look like excel ,if we want to
extract data from excel which saved in my documet how can i
get that in datatable using vb script

Answer Posted / jyotikrushna mohapatra

You can do by just parameterizing it.Let's explain with an
example. You have a datatable let table.xls in C drive and
if you want to extract the data from this excel file into
your document then write in the pane

datatable.importsheet "C:\\table.xls",1,destination

Here destination means where u have to place the data

Is This Answer Correct ?    2 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can u describe what kind of testing are for OTC derivates by banks.

1668


How to replace junk code recorded by QTP with a mall function.

1646


Can anyone send me a vb script function for verifying the functionality of active links on a web page

1600


How to get the length of the string by making use of the string function?

567


Which in-built function is used to format the number in the vbscript language?

579






What are subprocedures in vbscript?

664


What are class events?

583


What are the disadvantages of vbscript?

655


Explain some uses of vb script?

553


How to capture a runtime error in vbscript?

629


Can someone please tell me what poor design in a relational database (not the layout or style) is and how it can be avoided? PLEASE...im desperate.

1415


Which command is used for writing text on a page?

576


Mention how to create a cookie using vbscript?

531


What are keywords in the vbscript language?

527


What is vbscript procedures?

602