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
- 7836 Views
- HP, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Name the properties you would use for identifying a browser and page when using descriptive programming?
How is UFT 11.5 version different from UFT 12.0?
How to do call a output parameter from one action to another action??/
which type of testing process are you following in ur company? how to recognize a qtp page?
What are the steps involved in recovery scenario wizard?
What is synchronization point in QTP?
Explain the difference between call to action and copy action?
Explain about business process component? types and usage?
Did QTP prove efficient for your project? Yes or No, explain?
Describe synchronization point.
I am a new tester that needs to create an automatic script involving security questions. On a webpage I need to select a security question(which are random) from a drop down menu, and then input the answer as the last word from the security question. I have the script set-up to automatically select the first security question from the drop down. The problem I am having is trying to insert the security answer. How do I insert the security answer based on the selection from the security question?
how to create flat file datasubmission in qtp
how can we do the frame work in qtp
what is the difference betn QTP 8.0 AND PREVIOUS VERSION
"What are the common constrains that we need to consider when we prepare testcases for ASP application". Thanks in Advance...
