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 |
How to execute the test cases using QTP. i.e What is the use of QTP while execution
Explain advantages and disadvantages kdf?
What is a Dictionary object in QTP.?
Describe synchronization point.
For what purpose to we use object repository in a application?also explain usage of obj.repository?
Syntax for how to call one script from another and Syntax to call one "Action" in another?
I have multiple radio buttons i need to select a radio buton and i dont want to hard code i have a generic function for it there i have used select#0 so it selects first radio button but for other script i want to select the 4th radio button how i can make it still more generic
4 Answers Accenture, Acentia, LM,
1>why parameterization is necessary in qtp? 2>if we give constant value then what problem?
Gmail application is there.On that Inbox so many mails are there including naukari mails. On that mails i can select the only naukri mail checkboxes. plz tell the descriptive code for the above..
does the vb script knowledge is mandatery in testing using QTP
how to write xml output check point bu useing descriptive programing .means without useing output check point
if you run one test script in internetexplorer the same test you run in mozilla ffirefox is it possible or not how is it.