Sign Up Login


  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 does quicktest professional identifies the object in the application?

0 Answers  

how to use import and export sheet methods in qtp

1 Answers  

I am using DataTable.ImportSheet method to import the data from an excel sheet to the Runtime DataTable of QTP. here is my piece of code DataTable.import("c:\DataSheet.xls","Members","Members") The first row headings of Members sheet of DataSheet.xls and Members sheet of QTp are matched. but the QTP is taking very long time(approximately half an hour) to import the data into runtime datatable even though the DataSheet.xls has one or two rows in it. Please let me know why this is happening and is there any alternative for impoting the data into runtime datatable of qtp ?

2 Answers  

What is diff. between ordinal identifier INDEX and Location?

3 Answers  

hi everybody this questions is only for qtp real time users. anyone please clearly explain the approach u r following for qtp testing in ur company or qtp framework u r following in ur company pelase give me clear explanation then u did great favour to inexeprienced qtp users

0 Answers   Automobile, EDP,




Please let know the scripts for counting number of repeated letters in the word. Note repeated letter should not be count agian. Ex: If "Hello" is my word... l is coming twice.. it should count once and print... secong 'l' should not count again..

5 Answers  

Hi How to retrieve data from web element line by line?

0 Answers  

can we create recorset with out using database connection in vbscript?

1 Answers   CSS, CSS Corp,

suppose the given string str = {"vamsikrishna%%&%*&**"} count the no of vowels and special characters are repeated

2 Answers  

Could you please any body help me.for example in web table in the first row and first column there are 3 links like l1,l2,l3 having indexes 0,1,2 but second time links will change their order like l2,l3,l1 and indexes also changed how can we handle this situvation with script....

2 Answers  

When i use paramateriztion for tickets in flight reservation application , the tes'll run for first iteration but for the second iteration it'll give this details, but the second iteration is failed. Pls anyone clarify it. Cannot find the "Agent Name:" object's parent "Login" (class Dialog). Verify that parent properties match an object currently displayed in your application.

2 Answers  

Give me exact application where we should use low level recording?

6 Answers   CTS,

For more QTP Interview Questions Click Here
Categories