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...

  1. Categories >> Software >> Testing >> Automation Testing >> QTP
  2. Suggest New Category

Hi, how can we retrieve a specific value from Excel Sheet
(Not datatable. for externel file).i mean to say from .xls
file.

and also tell me from xml file and .doc file.

and how can u parameterize ur script from .xls file.(Not
data table).

Question Posted / nanda.d

Answers were Sorted based on User's Feedback



Hi, how can we retrieve a specific value from Excel Sheet (Not datatable. for externel file).i mean..

Answer / shyam

Hi I can divide ur question in to 3 parts
1. for xls file
2. for xml file
3. for doc file

1. For xls it is
GetCellData (Row, Column)
2. For XML
XMLFile(description).GetData
3. For Doc file it is
ReadLine( )


Any more querys in this then feel free to mail me to
testingwithshyam@gmail.com

Is This Answer Correct ?    1 Yes 3 No

Hi, how can we retrieve a specific value from Excel Sheet (Not datatable. for externel file).i mean..

Answer / nidhi jain

first you need to import datatable
Datatable.import("datatablename with path")

after importing table you need to call get method
Datatable.getCellData('columnname','datatable type')

Is This Answer Correct ?    1 Yes 4 No

Post New Answer

More QTP Interview Questions

wht is Driver in Integration testing. Anubody can answers it

7 Answers   CTS,

how qtp will recognise if application is run on many browsers

1 Answers   Cap Gemini,

how to load all resource files(function libraries,object repositories etc) into tests without associating them?

1 Answers  

What is qtpro? What is quick test pro? What is a quick test professional?

0 Answers  

Could you please explain me about QTP framework.

2 Answers   Oracle,

Hi, It is HR question. What are the qualities you like and dislike in your Project Manager?

2 Answers   TCS,

How many types of recording modes in qtp? Which will be used when?

0 Answers  

we have 5 default properties we want add more Default property in Object Repository how to add the property

2 Answers   Nous,

Hello Everyone, In QTP we have one option Data Driver wizard that comes in Tools -> Data Driver. so, please tell me abtout the use of Add Value and Parameterize options available in Data Driver wizard. And also the concept of value, constants, Parameterized displayed in the wizard. Please explain by giving the example. Thanks in advance, Gaytri

2 Answers  

What is the default add-ins in qtp?

0 Answers  

can any one tell me what is process metrics and what is product metrics if possible give me example. Thank You

2 Answers  

How to supress warnings from the "Test results page"?

3 Answers   Crea,

For more QTP Interview Questions Click Here
Categories