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

Answers were Sorted based on User's Feedback



in qtp we ve datatable look like excel ,if we want to extract data from excel which saved in my do..

Answer / 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

in qtp we ve datatable look like excel ,if we want to extract data from excel which saved in my do..

Answer / turtlerock

Datatable.import("c:\one.xls")

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More VB Script Interview Questions

how to genarate a random numbers in vb?

2 Answers  


where can i learn VB scripint ?

0 Answers   Satyam,


Explain about the extension .hta?

0 Answers  


HOw we can apply web service checkpoint in QTP 9.5? I tried it out with net connection also. But not getting success.

0 Answers  


filter the array values without using filter function?

0 Answers   CSS Corp, WQED,






how to write basic programs in VB Script like addition, multiplication?

14 Answers  


How to search word in a string without using instring function?

1 Answers   CSS Corp,


How to Pass Multiple values in functions by using vb script? Function value(arg1,arg2) N1=arg1+arg2 N2=arg1-agr2 N3=arg1*agr2 N4=arg1/arg2 Value= How to pass ? End Function

3 Answers   iGate,


What is parametrization ?

9 Answers  


hi Set myobj=Description.Create() myobj("type").value="submit" myobj("name").value="google search" myobj("html tag").value="button" browser("title:=google").page("title:=google").webButton (myobj).Click i was running above code in one weak back it was working fine i got result,again i opened after few days ,again i was trying to run the code it shows run time error in last line of my code ,why ?pls answer my question?

0 Answers  


how to add action through AOM in QTP

0 Answers  


How do you write an SQL insert statement?

4 Answers   HCL,


Categories