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

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("<>") I have taken a for loop and changed the cells values (1 as i and another 1 as j) But still I am not able to get Plz kindly tell me know this . It is very urgent

1928


How to Convert Hex color code to color name in VB Script?

4095


How will you format a number in percetage format in vbscript?

728


How will you get the octal value of the given number in vbscript?

651


Mention what are the rules to name variable in vbscript?

694






Write a code to print numbers from 5 to 0?

871


Explain about .wsf files?

757


what is used of Property........End Property loop ? how to write the script for it?

1857


Explain about tristate constants in vbscript?

773


Explain about the support of asp for vb script functionality?

662


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.

4912


What are string functions in vbscript?

782


Out of the different type of operators, which are evaluated first and last in the vbscript language?

720


What are the special sub-types in vbscript?

696


while using Keyward driven framework in QTPif new requirements are added how to manage it...plz ans

1736