![QTP Tutorial](/qtp/images/qtp-mini-logo.jpg)
- QTP Tutorial
- QTP - Home
- QTP - Introduction
- QTP - Test Automation
- QTP - Environment Setup
- QTP - Record and Play Back
- QTP - Object Repository
- QTP - Actions
- QTP - DataTables
- QTP - Checkpoints
- QTP - Synchronization
- QTP - Smart Identification
- QTP - Debugging
- QTP - Error Handling
- QTP - Recovery Scenarios
- QTP - Environment Variables
- QTP - Library Files
- QTP - Test Results
- QTP - GUI Objects
- QTP - Virtual Objects
- QTP - Accessing Databases
- QTP - Working with XML
- QTP - Descriptive Programming
- QTP - Automation Object Model
- QTP - Frameworks
- QTP - Designing a Framework
- QTP Useful Resources
- QTP - Questions and Answers
- QTP - Quick Guide
- QTP - Useful Resources
- QTP - Discussion
QTP - Datatables
A DataTable, similar to Microsoft Excel, helps the testers to create data-driven test cases that can be used to run an Action multiple times. There are two types of Datatables −
Local DataTable − Each action has its own private datatable, also known as local datatable, which is can also be accessed across actions.
Global DataTable − Each test has one global data sheet that is accessible across actions.
The data sheet can be accessed from the "Data" Tab of QTP as shown below −
![Data Table in QTP](/qtp/images/qtp_datasheet_1.jpg)
To execute a test case for some specified number of iterations, one can set the iterations of global datatable in the Test Settings dialog, that can be accessed using File → Settings → Run(Tab) as shown below −
![Data Table in QTP](/qtp/images/qtp_datasheet_3.jpg)
Example
For example, if a user wants to parameterize "compound Interest" of http://easycalculation.com/ that can be accessed using http://easycalculation.com/compound-interest.php. The Parameters can be created as shown below. Most of the functionalities of Excel can be used in Data table as well.
![Data Table in QTP](/qtp/images/qtp_datasheet_2.jpg)
DataTable Operations
There are three types of objects to access DataTable. DataTable operations can be well understood by traversing through the following −
Sr.No. | Object Type & Description |
---|---|
1 | Data Table Methods
Gives detailed information about the data table methods. |
2 | DTParameter Object Methods
Gives detailed information about the DTParameter methods. |
3 | DTSheet Object Methods
Gives detailed information about the DTSheet methods. |
To Continue Learning Please Login