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
I need to get some data from data base and store this
(retrieved) data in a excel sheet using VB script in QTP9.0
I have created connection for data base
I have created as excels sheet by using
Set XL=CreateObject("Excel.Application")
XLworksheet.cells(1,1).value= rs.fields.item("<
How to Convert Hex color code to color name in VB Script?
How will you format a number in percetage format in vbscript?
How will you get the octal value of the given number in vbscript?
Mention what are the rules to name variable in vbscript?
Write a code to print numbers from 5 to 0?
Explain about .wsf files?
what is used of Property........End Property loop ? how to write the script for it?
Explain about tristate constants in vbscript?
Explain about the support of asp for vb script functionality?
how to write a vb script in QTP for yahoo registration form, i want to check the performance also like performance test, stress, load test like that.
What are string functions in vbscript?
Out of the different type of operators, which are evaluated first and last in the vbscript language?
What are the special sub-types in vbscript?
while using Keyward driven framework in QTPif new requirements are added how to manage it...plz ans