in qtp we ve datatable look like excel ,if we want to extract data from excel

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

Question Posted / nidhi

2 Answers
8725 Views
I also Faced
E-Mail Answers

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

which is the bset training centre to learn automation tools?

2 Answers

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

0 Answers

Mention what is the main difference between function and sub-procedure?

0 Answers

When are redim statement and preserve keyword used in the vbscript language?

0 Answers

Mention characteristics of sub procedures?

0 Answers

I am running a windows based application.While running the script on QTP ,The Application pop-up an Error Message as "object Disabled" in two different scenarios Scenario 1-->The Application pop-up up a Message for Max Session Reached(as the application is set to hold 2 session and if if crosses the pre-defined limit then the error message pop-up) Scenario 2-->When Network connectivity is disabled the Application screen gets greyed out in colour with no operation possible. Now through Exception handling features in QTP ,we need to do the following For Scenarion 1-->Through Exception handling we need to just accept the Message pop-up in the Application and and resume with the call function as is for Scenario 2--> Through Exception Handling featutes on QTP we need to shut down the client , restart the client and resume the call functions as it is Note: The Application returns an Error Message as "object disabled" in both the cases i.e for pop-up message and when the Apllication getting greyed out due to Network failure how can we enhance the script in such a way that for the same error message retured by the application in two different and how to handle them????

2 Answers Sasken,

Can anybody code this problem for me in VB script - Create an array of 4 elements, increase its size to 7 elements and then find out which of the elements are prime (use functions)

2 Answers

how to retrive the tooltip by using descriptive programming in qtp?

3 Answers iGate,

What are the special sub-types in vbscript?

0 Answers

Set srchobj=Description.Create() srchobj("type").value="text" srchobj("name").value="q" srchobj("html tag").value="input" browser("micclass:=google").Page("micclass:=google").webedit (srchobj).Set "qtp" what's wrong in my code pls tell me ? the above code working fine and i got my result pass,now i am trying to run the program it shows general run time error why?pls help me i am in learning stage ?

0 Answers

how to operate webobjects in a webpage using getobject function and then using generic methods?

0 Answers

write a vbscrpit to swap values

2 Answers Adani,

For more VB Script Interview Questions Click Here