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 / nidhi jain

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

Explain the difference between check point and output value?

486

How reliable are the site's Internet connections required to be? And how does that affect backup system or redundant connection requirements and testing?

692

PLEASE TELL ME WHEN DO YOU USE THE OBJECT SPY AT RUN TIME

5921

What is the basic concept of quicktest professional (qtp)?

571

what is the advantages and disadvantages of using functions instead of re usable actions

1418




This is a question thats generally asked in every QTP interview. What were the problems that you faced during automation and how did you resolve them?

1463

what is profile tool?

1598

Discuss quicktest professional (qtp) environment?

570

Can anyone share/send me QTP 8.2 Crack as I had it before but now it's virus affected. Pls send me on Sawale.vijay@gmail.com Thanks, ~Vijay

2655

What is method name to compare two XML files.

1528

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

1970

I recorded a Web App with a Oracle backend using QTP 9.5 and for some reason the scripts don't play back> What am I missing at this point. I recorded the same Apps under Sybase and they work great. This is Oracle 10g. Why won't my scripts play back.

1503

when a test case is written how u test using qtp

1642

Can any one say what exact diff between test->parameters, action properties-> parameters. after defining the parameters in test->settings, how can we access those parameters.(i know how to use action prop parameters)

1614

Explain process of smart Identification in QTP?

595