Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 9068 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 |
anyone can explain the following concepts. 1.diff b/w Linear and modular framework 2.diff b/w keyword and hybrid framework
what is descriptive.create()in qtp?
Explain actions in qtp ?
what is check point?
describe common problems of test automation?
what is meant by descriptive programming?
Can any body explain me how to prepare QTP frame work with an example?? alexander.gdk@gmail.com
Hi All As per the requirements i have to copy the data from word document to excel sheet using the QTP Note : Data in word document is in tabular format i.e there is 80 rows and 5 columns table Can any body provide code for this ? Thanks in advance Regards Test123Test
How do u write a regular expression for date (dd/mm/yyyy) field ?
How to import a test case present in ".xls" file to TD under a Test set?
examples of user definied functions? how to write user defined functions in qtp9.2?
What is test object model in quicktest professional?
WinRunner 
