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

hi frinds i need help .i have 4 + yrs exp in testing and nearly 2 yrs exp in QTP and QC .currently iam working north fast 2 yrs iam looking for job in south is there any openings plz letme know my mail id is pbre1980@gmail.com

0 Answers  

What is runtime objects and test objects? What is the difference between them?

7 Answers   IBM,

What scripting language QTP of?

4 Answers  

How to capture a window in qtp or how to take snapshot of any window while writing script in qtp

3 Answers  

i need to add 1000 users in a domain i written the script for that and it is running successfuly but the problem is that my system is not the user of that domain in which i have to add users so for adding users in that domain i have to install qtp on that another system, can anybody suggest me the way to add those users from my system ultimately i want to know how to access remote computer through script

0 Answers  




what is the frame work in J-meter?

0 Answers  

hi how could i get installation guide for QTP 9.0 on XP help me for this !!!!!

1 Answers  

I am using "QTP 9.0" in my system, need to install java add-ins to test the java based applications, please prvide information from where i can get those java add-ins for QTP 9.0

0 Answers   Infosys,

give me descriptive programing code sample flight application in qtp?

8 Answers   CA, IBM,

What is the concept of hooking in QTP?

1 Answers  

How to capture data from images in QTP and produce them in Excel sheet ?

4 Answers   iFlex, QA InfoTech,

What is the difference between analog and low level recording?

0 Answers  

For more QTP Interview Questions Click Here
Categories