Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 8442 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
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 ?
write a program to display configuration of a local system with the help of vb script.
what is diff between static and dynaic arrys?
Mention what is the use of option explicit in vbscript?
In what way program "hello world" you can write in vbscript?
What is byref and byval parameters in vbscript?
Program to use input box and send even numbers into sheet1 and odd numbers into sheet2 and prime numbers into sheet3 using vbscript(QTP)?
What is vbscript procedures?
what is the difference between modular and data and keyword driven framework
Why is it recommended to close the database connection every time after the work is completed?
How can you fetch the value of a cookie?
Hi Friends, I have an issue like the describe below: I'm using QTP and I'm testing on SharePoint. As you knoe, SharePoint has a customize function for user, so that, If I add an object Web Table at the first time, that object was recognized by "index" and "html tag", after that, if someone change the display of web part, the "Index" of my object was changed as well and QTP unable to select that Web Table. Can you guide me how to identify or anyway to keep that Web Table object as unique object? Thanks a lot.
Anyone have qtp11.0 crack?
Which object is used to work with the database in the vbscript language and what statement is used to create this object?
What are class properties?
