Hi, how can we retrieve a specific value from Excel Sheet (Not datatable. for e

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

2 Answers
8340 Views
Cap Gemini, I also Faced
E-Mail Answers

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 load all resource files(function libraries,object repositories etc) into tests without associating them?

1 Answers

what is the difference btn risks & Therads in the Test plan documentation?

0 Answers Accenture,

For what purpose to we use object repository in a application?also explain usage of obj.repository?

3 Answers

1. Can anyone help me with recovery scenarios, each type with examples and also what is on error resume next?

1 Answers

wt is the use of multiple questions in QTP

0 Answers DigiTech,

Give me the Example of standard check point and text check point with syntax?

3 Answers IMI Soft, IMI Soft Engineering,

1.IF SOME OBJECT IN APPLICATION IS NOT IDENTIFIED BY QTP? HOW WILL YOU OVERCOME THIS? 2. WHEN AND WHYDO U GO FOR DESCRIPTIVE PROGRAMMING? 3. WHAT IS THE DIFFERENCE BETWEEN VB AND VBA? 4.WHAT ARE THE REGULAR EXPRESSIONS YOU USED? 5.IF ANY REQUIREMENT IS ADDED IN YOUR PROJECT, HOW WILL YOU PROCEED TO DERIVE THE TEST CASES AND HOW WILL YOU PERFORM AUTOMATION FOR IT?

2 Answers RBS,

Hi Frriends... I have one Query please give the apropriate ans. when we r working with web based application , the user loggedin page name is changed respect to the username ( Take a exp. Yahoomail.com) .When we use Datadriven test to this scenario ,each time the loggedin page name is changed ...then the script is fail.. at that time wat can do... please give the apropriate ans. Thanx in advance..

3 Answers

How to find RAM size by using QTP?

2 Answers IBM,

What is a runtime datatable ?

2 Answers Ordain Solutions,

How to map Test cases to the script? Please do anwser urgently?Thanks

3 Answers

UFT 12.02 which ALM version will support

0 Answers

For more QTP Interview Questions Click Here