Which MS Excel formulas are possible to use in the
DataTable? I am searching a formula for searching a field
in the datatable
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / vikram
ur question was not clear 2 me ,
but 2 open excell sheet which is already created
we use
set obj=createobject("excell.application")
obj.workbooks.open"path of excel sheet"
to get data from excell sheet,we use
v=obj.sheets(1).cells(i,j)
msgbox v
i means rows
j means columns
to insert data in to particular cell, we use
obj.sheets(1).cells(i,j)="vikram"
to count no.of.rows.we used
v=obj.sheets(1).usedrange.rows.count
msgbox v
to count no.of.coloums.we used
v=obj.sheets(1).usedrange.columns.count
msgbox v
| Is This Answer Correct ? | 1 Yes | 3 No |
we use a file extension .properties why is it used and where do we use it plz help me out with detailed explanation and navigation of how to use on the QTP 8.2?
what is the difference between modular framework & datadriven framework
hai friends i already ask this question but when i post the question the alignment goes wrong .....my question is we have a WEB TABLE ....assume that web table having 3 row's and 3 column here in 2nd row 3rd column having VISIT FACEBOOK link...now i want to check the VISIT FACEBOOK link is available or not ..if it's there i want to click the link ...then how to find the web table row or column count ....don't write the excel or data table script here friends .....consider that it's a WEB TABLE do a favour ...thank's
Define object spy ?
How to find the name of the machine where you are running your automation scripts in qtp?
How to create a standard checkpoint ?
from what stage you will start automation in your project
do you prepared framework,pls answer this
Can any one explain me what is the procedure to connect the remote desk by using QTP 9.2 ?
How to take screenshots in qtp?
Hello, Is there any way to send the test results in html format (or any other) by email using outlook after the test run ends? thank you in advance
What are the points to be taken into consideration while doing desktop testing?