QTP-Excel Object Model

QTP-Excel Object Model

Excel Object Model:

Creating an Automation Object in Excel.Application class

Excel Scripting Examples:

• Create an Excel file, enter some data and save the file through VB script?
• Check if the Excel file exists or not, if exists open the file and enter some data, If not Exists create the file and enter some data and save the file through VB script?
• Data Driven Testing through an External Excel Sheet
• Data Driven Testing using Data Table methods
• Calculator Example using Data Table methods
• Open an Excel Spreadsheet
• Read an Excel Spreadsheet
• Add Formatted Data to a Spreadsheet
• Sort an Excel Spreadsheet on Three Different Columns
• Short an excel sheet column
• Add New Sheet to Excel File
• Rename Sheets in an Excel File (WorkBook)
• Add a Sheet to an Excel File (WorkBook) and change the Position

Database Object Model

o        ActiveX Data Objects

o        ADODB Connection Object & Recordset Object

o        Test Database Creation & Collecting Test Data

o        Databases Connections (Ms-Access, SQL Server and Oracle)

o        Data Driven Testing by fetching Data from a Database

o        Data Comparisons

Regular Expressions

• Understanding & Using Regular Expressions
• Handling Dynamic Objects
• Using Regular Expressions in Checkpoints
• Defining Regular Expressions
• Search Operations
• Regular expressions in Recovery scenarios
• Regular Expression Object

Error Handling

• Overview on Error Handling
• Error Handling Methods in QTP
• Synchronization
• Exist Property
• Exit Statement
• On Error Statement
• Recovery scenarios

GUI Scripting

• Handling GUI Objects
• Object State Verification
• Input Domain Coverage
• Output Domain Coverage
• GUI Script Examples

Web Scripting

• Checking Links
• Testing Forms
• Output Domain Coverage
• Cookies Testing
• Web Script Examples

Introduction, Basic Framework

• Automation Framework, Types of Framework
• Creating Folder Structure
• Creating & Storing Automation Resources
• Organizing & Managing Resources
• Generating Driver Scripts
• Generating Initialization Script (AOM Script)

Data Driven Framework

• Test Data Collection
• Ways of Parameterization
• Data Driven Implementation Techniques
• Using Data Table Methods

Keyword Driven Framework

• Keywords
• Keyword Driven Approach
• Creating Functions
• Creating Test Automation resources
• Creating Organizer Spread sheet
• Generating the Driver Script
• Generating the Initialization Script

Hybrid Framework

• Hybrid Automation Framework
• Keyword Driven & Data Driven Test Approach
• Advantages of Hybrid Approach
• Organizing & Managing Resources