Which MS Excel formulas are possible to use in the
DataTable? I am searching a formula for searching a field
in the datatable

Answer Posted / sandeep

Please refer to the folder with your SCRIPT name stored on
your DRIVER.

QTP create folder with Test name at a location where you
saved Script.

Now in same folder one file exist Default.xls.

This Excel file will contain all your datasheets for all
actions.

Open same file in MS - EXcel. And enter any formula you
want to enter.

I hope this solves problem,

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do we handle run-time errors?

583


I want to do QTP Certification what is the pattern of Question paper.

1745


What is active screen?

565


I want to know can we integrate visual source safe tool with QTP and QC for our version controlling process? WE know QTP and QC 10.0 version is having the version control inbuilt in it but I want to know the merits and demerits of the inbuilt version control tool and the visual source safe tool using QTP and QC.

2469


In qtp, explain what is qrs file?

583






Explain measuring transaction.

586


Give the syntax to import/export xls into qtp.

588


An action has both shared and local OR associated with it and both have the same object in them. In the test which one will be considered?

574


Explain the checkpoint in qtp?

595


i'm testing the webpage with QTP, in this wabpage i have to choose the CV from the window, but QTP can't recognize the object, so i used the Low LEvel Recording, but every time i run the test, QTP go to halt when it gets to the Recorded part, any solution for that?( except puting delay in the script and manuall selecting, because i've did that)

1555


RECENTLY I PLACED IN QTP..HOW TO IMPROVE VB SCRIPTS KNOWLEDGE? IAM STRUGGING TO WRITE THE AUTOMATION SCRIPTS? ANY BODY TELL HOW TO IMPROVE QTP SCRIPT SKILLS?

2185


What is data driver in qtp? Where we use it?

569


What are the various automation frameworks available in qtp?

512


could any help me please, how to work on visual foxpro application using UFT

1689


Explain actions in qtp ?

561