QTP Excel Read

QTP : Read Data From Excel

Quick Test Professional(QTP) which latest version is Unified Functional Testing(UFT) is a Automation testing tool. For testing purpose lot of time it is needed to read data from Excel file or write data at excel file. Also at the time of developing Framework data or keyword are in excel file, using that data QTP/UFT script will run. How to read and write data from excel I will show you that code. It's very simple and easy but very important too.
The code is in the image. Only create a excel file and give that excel path with the script it will work.

QTP Excel Read


UFT/QTP Topics

UFT/QTP widely used for Software Automation Testing. For better practice of UFT/QTP you have to understand the following topics clearly:

*    Object Repository
*    Object Spy
*    Actions
*    Data Table
*    Parameterization
*    Regular Expression
*    Checkpoints
*    Synchronization
*    Smart Identification
*    Debugging
*    Error Handling
*    Recovery Scenario
*    Environment Variable
*    Library Files
*    GUI Objects
*    Virtual Objects
*    Accessing Database
*    Working with XML
*    Test Result


The description of the above topics will be posting soon.

Recording Mode

Recording mode of UFT/QTP:
There are 3 Recording mode of UFT/QTP 1) Normal Mode, 2) Low Level Mode & 3) Analog Mode.
Normal Mode:
UFT uses normal mode by default, which records almost everything.
Low Level Mode:
When normal mode fails to record any object due to recognition problem then Low Level Recording Mode to force UFT to record specific object.
Analog Mode:
Analog Mode is used to record the recognition of Keyboard inputs, mouse clicks & signature.

Functional Testing By UFT

HP Unified Functional Testing (UFT) is the new version of HP Quick Test Professional (QTP). The market leading Automation Testing tool.
You can download this Software(Trial Version for 30 days) from HP site at the following link:

Testing Process Of UFT:

Testing Process Of UFT as follows:
01)  Creating Script a. By Recording, b. By Descriptive  Programming.
02)  Enhance Script.
03)  Debugging Script
04)  Running Script
05)  Analyze Test Result
06)  Reporting / Reporting Defect(If any)