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
- 8718 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
We have an application which is built using multiple technologies and are using QTP as the tool for Automating the same. While we spy over a combo box in this application, we get the object name as a "Combo Control" and we are not able to perform any action over this object in either selecting or checking any method for the same like "Exist" etc. Hence we thought of a solution and the same can be found below
Which operator can be used to check if two numbers are equal or not in vbscript?
How to declare an array in vbscript?
What is the purpose of on error resume next statement?
Which operator can be used to do an xor operation in vbscript?
Write a test case using Test if the images,a particular test exists,check if the page links match,page response is within a certain range,parameterization of the test,the test should comprise of actions,the test should use a custom function,the test should use global repository
What is vbscript?
How can you test font size, type and color using QTP tool?
What is parametrization ?
i have developed the below QTP script to count the no of items available in the web list "Select a product" in www.bankrate.com and also want to print what are the items??? can any one help me to rectify the below script??? SystemUtil.Run "iexplore.exe","www.bankrate.com" a=Browser("title:=Mortgage Rates Credit Cards Refinance Home CD Rates by Bankrate.com").page("title:=Mortgage Rates Credit Cards Refinance Home CD Rates by Bankrate.com").Weblist("name:=select").GetTOProperty("items count") msgbox a Dim List() ReDim List(a-1) For i = 1 To a List(i-1)=Browser("title:=Mortgage Rates Credit Cards Refinance Home CD Rates by Bankrate.com").page ("title:=Mortgage Rates Credit Cards Refinance Home CD Rates by Bankrate.com").Weblist("name:=select").GetItem(i) Print List(i-1) Next
How do you get the value of a combo box in Javascript?
How regexp.execute method works?
ASP 
