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
- 9218 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
How can I check if a environment variable exist or not?
Hi All, I have QTP installed on my machine but the application under test (AUT) is on remote desktop.My scenarios is like that,it should contain following steps. 1)Automatically it should click on start and then on remote desktop connection. 2)it should enter the IP address and then connect to remote desktop. 3)and then it should be able to record the application in remote machine and then run it also. Can somebody tell me how to record the application which is in remote machine.
Hi,All How to create a link in excel sheet using qtp
in my application,validation message has in japanise language.how to validate this message is appears properly or not
Explain features of the latest version of qtp/ uft 12.1?
explain keyword driven framework with banking domain?
what difference between runtime object and text object and what property they have. whether they have same properties or different properties.
Can we call qtp test from another test using scripting. Suppose there are 4 tests and I want to call these tests in a main script. Is this possible in qtp?
What is the use of sendkeys and what are send keys
in a web page hoe to check the dynamic links that rechabging with out using regular expressions
describe some problems that u had with automating testing tool?
What is quick test pro?
Want to verify notepad reports using QTP framework or any other BV script method. Can anyone share the method to achieve it? Eg. Person Name is the header and the actual name is John then how can we verify weather person name is John
How to capture all the data of a webtable, weblist and combolist using QTP?
images are dynamically changes how to compare two images with out using the bitmap
