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

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

813


Explain the string concatenation function in vbscript?

711


Mention what is vbscript?

799


Explain the support of asp for vb script functionality?

821


Mention what if you do not specify anything when you call a procedure?

751


Mention the environments where vbscript could be run?

891


Compare java script and vb script?

817


How many types of procedures are available in the vbscript language?

730


In what way program "hello world" you can write in vbscript?

868


How will you get the smallest subscript of an array in vbscript?

1086


By default in vbscript the arguments passed to functions and subroutines are by reference or by value?

825


What are the environments supported by vbscript language?

688


Explain about .wsf files?

823


What are the valid scopes of a variable in vbscript?

796


What is the difference between for loop and while loop?

777