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

we use a file extension .properties why is it used and where do we use it plz help me out with detailed explanation and navigation of how to use on the QTP 8.2?

0 Answers  


what is the difference between modular framework & datadriven framework

0 Answers   SDS,


hai friends i already ask this question but when i post the question the alignment goes wrong .....my question is we have a WEB TABLE ....assume that web table having 3 row's and 3 column here in 2nd row 3rd column having VISIT FACEBOOK link...now i want to check the VISIT FACEBOOK link is available or not ..if it's there i want to click the link ...then how to find the web table row or column count ....don't write the excel or data table script here friends .....consider that it's a WEB TABLE do a favour ...thank's

3 Answers  


Define object spy ?

0 Answers  


How to find the name of the machine where you are running your automation scripts in qtp?

0 Answers  


How to create a standard checkpoint ?

0 Answers  


from what stage you will start automation in your project

5 Answers   TCS,


do you prepared framework,pls answer this

1 Answers  


Can any one explain me what is the procedure to connect the remote desk by using QTP 9.2 ?

0 Answers   IGI,


How to take screenshots in qtp?

2 Answers   Sonata,


Hello, Is there any way to send the test results in html format (or any other) by email using outlook after the test run ends? thank you in advance

0 Answers  


What are the points to be taken into consideration while doing desktop testing?

1 Answers   Cap Gemini,


Categories