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

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the various automation frameworks available in qtp?

506


What is the parameterization? Give one example?

594


What is an expert view and keyword view?

570


How will you test a keyboard?

601


What are advantages of test automation?

663






What are the types of object repository in qtp?

567


any body can you help me what is the script to automate an comand promt

1976


Hi, I am supposed to automate mainframe application through qtp. I do not know how to start abt it. Can you plz help me in first initializing the process or do you anybody have a guide book or a link which guides me through the process of automating the mainframe applications and things involved in it.

6660


What is throw object?

1745


What is quick test pro?

590


What is quicktest professional (qtp)?

567


after click on compose mail how can we attached a file in qtp with vbscript code

1612


Explain how to use QTP to check broken links on a page?

585


What is the new version of qtp which is recently released in the market?

642


How do I lauch my test website using code from qtp in different environmet, uat and PPTE?

1461