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

How to execute the test cases using QTP. i.e What is the use of QTP while execution

2 Answers  


Explain advantages and disadvantages kdf?

1 Answers  


What is a Dictionary object in QTP.?

1 Answers   Cap Gemini,


Describe synchronization point.

1 Answers  


For what purpose to we use object repository in a application?also explain usage of obj.repository?

3 Answers  


Syntax for how to call one script from another and Syntax to call one "Action" in another?

1 Answers   Crea,


I have multiple radio buttons i need to select a radio buton and i dont want to hard code i have a generic function for it there i have used select#0 so it selects first radio button but for other script i want to select the 4th radio button how i can make it still more generic

4 Answers   Accenture, Acentia, LM,


1>why parameterization is necessary in qtp? 2>if we give constant value then what problem?

5 Answers   Wipro,


Gmail application is there.On that Inbox so many mails are there including naukari mails. On that mails i can select the only naukri mail checkboxes. plz tell the descriptive code for the above..

2 Answers   Impetus,


does the vb script knowledge is mandatery in testing using QTP

1 Answers  


how to write xml output check point bu useing descriptive programing .means without useing output check point

1 Answers  


if you run one test script in internetexplorer the same test you run in mozilla ffirefox is it possible or not how is it.

1 Answers   Satyam,


Categories