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

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

How to capture screen shots when an error occurs?

2 Answers  


can somebody send the script to write a multiplication table in notepad through qtp

3 Answers   AppLabs,


What is the parameterization? Give one example?

0 Answers  


Explain Different types of Checkpoints in Quick Test Professional?

2 Answers   Crea,


What's Checkpoints for QTP?

1 Answers  






where we save the scripts created in one project?

6 Answers   IBM,


i want information about API testing and i want info like how process can be done in company? i want added info like coding ,debugging, desing in c.v ? what should add in c.v for eg banking domin? pls any answer my question?

0 Answers  


How to create runtime property for an object?

7 Answers  


str="QTP AUTOMATION TESTING" here how many T are there in the str finally i want to display the T

10 Answers   HCL,


I dont know how to configure non standard objects to standard objects in QTP9.2 can i have someone explain me in breify?

3 Answers   TCS, Wipro,


How to connect to a database?

0 Answers  


Tell me few important difference Between QTP and WinRunner?

9 Answers   TCS,


Categories