Which MS Excel formulas are possible to use in the
DataTable? I am searching a formula for searching a field
in the datatable

Answers were Sorted based on User's Feedback



Which MS Excel formulas are possible to use in the DataTable? I am searching a formula for searchi..

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

Which MS Excel formulas are possible to use in the DataTable? I am searching a formula for searchi..

Answer / neeraj kumar

Addition of two column values...

Is This Answer Correct ?    0 Yes 1 No

Which MS Excel formulas are possible to use in the DataTable? I am searching a formula for searchi..

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

Post New Answer

More QTP Interview Questions

Can the user toggle between using Local OR and shared OR for the same action?

0 Answers  


hi to all, i need a code.. in flight application 1.i need to login first then i need to insert 3 new orders... 2.i have to log out 3.i have to login again with different user 4.need to insert 2 new orders 5.then need to log out 6.then again login with different user 7.3 new orders create and log out 8.but we hv to do this using data table and actions please help me

0 Answers  


how do you done Data-driven test using MS-Word Instead of DataTable

3 Answers   IBM,


For which type of projects the iterative model is not suitable?

0 Answers  


what is the automation framework that ur company using(actual procedure,not theoritically explination)

1 Answers  






what is profile tool?

0 Answers   ITC Infotech, TCS,


1.how can we report the QTP test result in a different excel sheet 2.

3 Answers   Aurigo,


hou can we use vb script in qtp could u tell me breafly

0 Answers  


Object recognition in QTP is based on which model ? a) COM b) DCOM c) DOM d) None of the above

2 Answers   Ordain Solutions,


How to test the mandatory fields in QTP?

1 Answers   SoftSolve, TE,


What is an environment variable?

1 Answers  


If you entered into yahoo mail with your valid user name and password , then you will get " welcome , username " (for example you will see , “welcome, Krishna” ) text on the top of the Inbox page , how can you test the user name is correct or not using QTP?

3 Answers   CTS,


Categories