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
- 2 Answers
- 7654 Views
- I also Faced
- E-Mail Answers
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
What are the valid scopes of a variable in vbscript?
Why is it recommended to close the database connection every time after the work is completed?
What are the special sub-types in vbscript?
What are class variables?
Explain the arrays in vb script?
Explain the scope of the variables using dim, public, and private keywords respectively.
How will you get the natural logarithm of the given number in vbscript?
What are the different types of loops available in the vbscript language?
Out of the different type of operators, which are evaluated first and last in the vbscript language?
how to automatically update the sql server2005 database records when insert in vb6?
Which in-built function related to an array joins substrings into one string in the vbscript language?
How can constants be declared in the vbscript language?
How to Convert Hex color code to color name in VB Script?
How can you create an object in vbscript?
What are class events?
