Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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

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

Where we can use the synchronization?

0 Answers  


HI I want to know the detials of QTP certifications such as syllabus, study Materil etc. Can any provide me all these details?? my mail ID is krishnuvk@yahoo.com

0 Answers  


Hi, i run scripts in one machine those r passed.when i run the scripts in client side those r failed.Give me such a scenario when ever u faced?

0 Answers   BirlaSoft,


explain how to write vb script in qtp?when will you write own script?

0 Answers   FirstApex,


Why you have to add the specific add in in QTP? My answer is to recognize the specific objects we have to add the add-in in QTP...but he asked again after adding addin how qtp recognize the objects successfully? what is there in the add-in ?

1 Answers   CTS,


Can any one give me some basic VB script used in QTP ?As i am new in QTP.Give sample VB script used in QTP? PLZ

3 Answers  


Without integrating QC/Testdirector with QTP, is it possible to keep track of the defects?If yes how? How to export QTP results to an excel sheet?

0 Answers  


4. what is the use of Text output value in Qtp?

1 Answers   Wipro,


how to generate numbers in between to numbers suppose numbers in between 500 to 1000 in sequencies using vbscript

1 Answers  


How does QTP identifies the object in the application?

1 Answers   Crea,


HI ALL I AM WORKING AS A AUTOMATION ENGINEER FROM PAST 2 MONTHS IN QTP,MY QUESTION IS IF I OPEN THE BROWSER FIRST & THEN THE QTP LATER MY OBJECT SPY WILL NOT WORK,Y IT IS SO..IF U HAVE THE ANSWER PLZ MAIL ME AT AKSHAR.MYSORE@GMAIL.COM

8 Answers   Infosys, TCS,


what is runmodes in QTP

1 Answers  


Categories