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 / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

What is method name to compare two XML files.

1537


What are the different types of qtp test assets and their extensions?

599


Are Shared ORs read-only?

628


How does you test a weblink which is changing dynamically?

552


Where we use data driver in qtp?

611






i have doubt suppose iam purly working in QTP, when i will work on sql and performence testing? pls any one clarify doubt?

1502


how do i know how to use tools

1453


How to test the login page in different ways in automation testing and i need code?

1346


hi all here i have tab named "Workbench" By clicking on "workbench" tab.it displays 4 tabs like below workbench common cargo commercial charter "common" tab have 10tabs inside,"cargo" tab also haveing 15 tabs inside and remaining two tabs also having few tabs inside. when clicked on "common" tab.it displaying the script like tab("workbench").select"common" if i clicked on "cargo".it displaying the script like tab"workbench_2").select"cargo" if i clicked on "commercial".it displaying the script like tab"workbench_3").select"commercial" if i clicked on "charter".it displaying the script like tab"workbench_4").select"charter" I have used a "FOR LOOP" for common,commercial,cargo,charter tabs.it was stopped at second tab SO, CAN I RECOGNIZE "WORKBENCH_2,_3,_4" AS A SINGLE VARIABLE if not, can anyone plese help me to solve this

1516


Can anybody let me know how to test the Drag and drop feature of the column in a .net application...eg..i hav to test the drag and drog feature of a table(swftable) in a application..plze help!!

1751


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

606


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


How to save your test using quicktest professional?

534


Explain the differences between table and db checkpoints?

581


If I change the property value at runtime is it effect is object repository?

608