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
- 8376 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 |
I am having major problems with some DB Table Checkpoints I add to my script. I 35 web based applications recorded and each has DB Table Checkpoints insert but only 1 script isn't recognizing the DB Table Checkpoints for some reason. I've checked the DB connections and the info in the Library Functions and still only this one script out of 35 doesn't recognize the DB Table Checkpoints. Can someone please help me figure out why only this one script out of 35 that's hitting the same database is having a problem.
What is the ur roles and responsibilities as automation testing engineer?
There are 4 webpages in an application, in third page there is one cancel button i want to click that cancel button only, how can I click that cancel buttton ?
how much space occupies in object respository by default?
how to do the batch testing in test director using manual testing procedure?
What's Checkpoints for QTP?
your coming from electrical backgroung..but y ur coming to software side?
Explain the terms test and business component?
How is UFT 11.5 version different from UFT 12.0?
Out of 3 recording modes. 1.Standard 2.Analog 3.Low-level, which one is commonly used. As per my knowledge, Analog is used for Graphs , barcoding or DIgital signatures.
WAT IS DATA BASE AND XML CHECK POINT ?HOW TO IMPLEMENT IT ... GIVE PROPER EXAMPLE FOR IT
what is descriptiveprograming? how to do object identification thrugh Descriptive and is possible smart identification or not
WinRunner 
