Which MS Excel formulas are possible to use in the
DataTable? I am searching a formula for searching a field
in the datatable
Answer Posted / sandeep
Please refer to the folder with your SCRIPT name stored on
your DRIVER.
QTP create folder with Test name at a location where you
saved Script.
Now in same folder one file exist Default.xls.
This Excel file will contain all your datasheets for all
actions.
Open same file in MS - EXcel. And enter any formula you
want to enter.
I hope this solves problem,
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
Describe the differences between functions and actions in UFT?
hi to all, i need a code.. in flight application 1.i need to login first then i need to insert 3 new orders... 2.i have to log out 3.i have to login again with different user 4.need to insert 2 new orders 5.then need to log out 6.then again login with different user 7.3 new orders create and log out 8.but we hv to do this using data table and actions please help me
Why bpt?
I have written a code to fetch values fro access db and place in the fields. Iam using GetROProperty to fetch runtime values. Now i want to add runtime values to the access db in field v3. please help me. Its not writting in the db. Option explicit Dim con,rs,db,c Set con=createobject("adodb.connection") Set rs=createobject("adodb.recordset") con.Open "Driver={Microsoft Access Driver (*.mdb)};dbq=D:\Sales.mdb" rs.open "select * from tax",con Do while not rs.eof Browser("Sales Tax Calculator").Page("Sales Tax Calculator").WebEdit("incost").Set rs.fields("v1") Browser("Sales Tax Calculator").Page("Sales Tax Calculator").WebEdit("intax").Set rs.fields("v2") c=Browser("Sales Tax Calculator").Page("Sales Tax Calculator").WebEdit("outtax").GetROProperty("value") rs.MoveNext print c Loop Do while not rs.EOF rs.EditMode rs.Fields("v3").Value="3" rs.Update rs.MoveNext Loop Set rs=nothing Set con=nothing
How extensive or customized are the server logging and reporting requirements; are they considered an integral part of the system and do they require testing?
what are the frame work models of qtp?which frame work you follow in your company?and explain it process?
Explain advantages and disadvantages kdf?
When do go for loop condition in test?
Can any suggest me what is exposure testing?
what is the difference between IE & Netscape in web testing on a log in page
How to make qtp understand the difference amongst the same type of objects .suppose there are 5 check boxes in a page and I have to choose the 2nd one, how to do that through script?
.have you ever written compiled module? if yes , tell me about some of the function that you wrote.
Hi Friendss..., can any body help me.. 1. Tell me your achievements(Technically)..? 2. Tell me your strengths(Technically) and weakness(Technical)..? 3. Why are you looking for change..?
Have you faced any problems with object repository?
how to know no.of mails in our g mail by using vb-script