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

How to convert manual test cases to automated testcases

1 Answers   TCS,

why we are using environment variables instead of global variables?

1 Answers   TCS,

What does VBS file contain...??? what is VBS file.. ???

6 Answers   GE,

HOW TO AUTOMATE CAPCHA IMAGES while creating Gmail account

2 Answers   TCS,

Without using gui map editor we can recognize the application in winrunner ?

0 Answers  

Why VB scripts are used in QTP and TSL in Winrunner, is there any advantage of using VB Scripts

2 Answers  

Hi cud you plz answer my question.. what is the size of Object Repository?

8 Answers   TCS,

How to capture the tooltip of webelement,if there are two values displayed in tooltip of webelement?

1 Answers  

When you open QTP, how many sheets you can see?

0 Answers   Wells Fargo,

Hi Friends, Im planning to do certifcation in mercury Automation Tool QTP.But I Didnt get any clear details regarding course syllabus, fees, where to approach, and which certification would be useful for the experienced testers? can any one send me the details?

0 Answers  

what is advantage of descripting programming in QTP?

3 Answers   ADP,

Can someone tel additonal features which has been included under QTP 9.0 which is not there in 8.2 version?

1 Answers  

For more QTP Interview Questions Click Here
Categories