Which MS Excel formulas are possible to use in the
DataTable? I am searching a formula for searching a field
in the datatable
- 3 Answers
- 7814 Views
- HP, I also Faced
- E-Mail Answers
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 get align property of the link on web page?
How many actions we can create with in a test?
QTP Data Table Having 10 records with 10 to 15 fields(lets say).now i want to get alternative records from datatable.pls can any one answer it?
write the vb script for call to new action in qtp?
can any one tell me what is process metrics and what is product metrics if possible give me example. Thank You
what are the areas that cannot be tested using an automated tool? list a few
What is the pros and cons between QTP and Rational Robot
How to insert screenshot on to the body of outlook? -1 how to use insert-picture tab in new email outlook to insert image in the body. Suggest something.......
Hi all, can anyone tell me the challenges u faced while using qtp?
How can I pass values from one action to another in QTP ?
What is the extension of QTP local Repository? If it is .mtr then what is .bdb extension stands for?
What is the difference between Action and Function.? when both has the same functionaltiy, when do we choose Action and when do we choose Function..??
3 Answers DST Global Solutions,
WinRunner 
