Which MS Excel formulas are possible to use in the
DataTable? I am searching a formula for searching a field
in the datatable
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 get the image text that changes dynamically? Here i have used "GetROProperty", but it's not working. I used like Ex:Browser("webmail").Page("inbox").image ("captchaimage).getroproperty("innertext/text/value")
Will there be any standards or requirements for page appearance and/or graphics throughout a site or parts of a site?
This is a question thats generally asked in every QTP interview. What were the problems that you faced during automation and how did you resolve them?
how to create flat file datasubmission in qtp
how to know no.of mails in our g mail by using vb-script
What is text/text area checkpoint?
What is keyword view in qtp?
How to create Reusable and Multiple Actions?
Hi All, How to get repeated word in string . Thanks Balaji
How to automate a script in mainframes environment? I have the terminal emulator Add in. Describe in detail.
What is test object?
How do you know the location Id of an object if you know its index id?
In the Hybrid framework, data can access the database, excel file, XML etc. Is it true?
How to save your test using quicktest professional (qtp)?
Hi we are running tests remotely from quality center and pushing tests into qtp boxes remotely, and it does execution but while uploading results back into quality center it hangs in qtp box.If any one come across similar problem, please send me details how to handle this. Thanks kris