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

How i can change shared repository to per test repository in qtp

1 Answers  


Approach for Installation,comaptibility,system testing

0 Answers   Diebold,


How many regression test suits in your appliction?

2 Answers   CTS,


What is the difference between a Function and Action in QTP?

0 Answers   Wells Fargo,


can u pls explain me About Driver script.

4 Answers  


How to import excel sheet to QC?

1 Answers  


What is the difference between Client/Server application and Web application ?

2 Answers   ArisGlobal,


any challange that faced in your project? (please give me some examples in your project?

1 Answers  


Which recording modes need more memory?

0 Answers  


What is the syntax to call one action in another?

0 Answers  


What is keyword view and Expert view in QTP?

9 Answers   Ordain Solutions,


Hi, Has anybody attended IBM interview on 17th APR 2010,and got offer letter? I had given interview and selected also but still did not recieve offer letter.

5 Answers   IBM,


Categories