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


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 can i select multiple values from drop down list using vb script in qtp? and wt is the script for clicking msg box box automatically with a specific time. Thanks in advance...Kalyani.

2 Answers   Accenture, CSC,


How to handle the exceptions using recovery scenario manager in QTP?

0 Answers   Crea, CTS,


Create flight reservation login descriptive programing (Condition: Remove the value and substitute with a variable, and then call the validation from Excel) Plz help me....... very urgent.........

0 Answers  


how to calculate no. of repeating characters in a a string..please give me the code

14 Answers   CTS, Hexaware,


what is the framework followed by ur company in qtp

5 Answers   Ordain Solutions,


How to open any application during Scripting?

3 Answers   Crea,


Deal All, Recently i face one interview question in one company. str="test12@#3456" In This i want to print like special character and numeric ,word in one script please tell me how to write the code for this Thanks Balaji

1 Answers  


What is the extension of qtp local repository?

0 Answers  


How to get all the objects count and objects names in webpage using QTP ?

6 Answers  


Explain how you can replace string in qtp?

0 Answers  


HI. Plz Clarifie my doubt,having 2+yrs experience in Testing , But My accedamics(Xth,INTER) are Less than 60%, But B.Tech 72%. It creats any problem , When i change to any MNC. plz tell me......... lot of friends told it's a problem, Some people says NO problem, What .............

3 Answers  


I want to grow as a Automation Engineer,Kindly help me in clearing my interview that what interviewer looks for as a Automation Engineer. I am having three years of experience in testing.

0 Answers   RBS,


Categories