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



Load Test Overview

HP LoadRunner is a Performance Testing Tool. For Performance Testing LoadRunner is widely used. Also there is couple of tool for Performance testing such as JMeter, NeoLoad etc. The following are LadRunner introduction & Performance testing process. LoadRunner has 3 part:
i)       VUGen (Free):
VUGen is one of three part of LoadRunner. It’s free no license required. You can create LoadRunner Script here. You can record playback your script here. Also script enhancement are done here.
ii)      Controller (License Required):
Controller is one of three part of  LoadRunner. The Performance testing scenario are created here & also run the test. This part of LoadRunner is licensed but you can use it as trial version for limited time.
iii)     Analyzer (Free):
Analyzer is one of three part of LoadRunner. It’s free. After completion of test run you can analyze the result here. After analyzing The Report are created here.

Load Testing Process:
For Load Testing you have to follow the following process. The process is very important for the test.
  • Requirement Gathering
  • Create Test Plan(Must Approved by the Project Team)
  • Create Script 
  • Create Scenario
  • Run Load Test
  • Analyze Load Test
  • Create Report with comments (Summary Report, Load runner Report, Monitoring Report)
If the report is accepted by the project team then load test is done. Otherwise you have to fix the problem & run load test again.


For video tutorial of LoadRunner please visit the TUTORIAL LINK.

Software Development Life Cycle

As a Software Tester everybody must know the Software Development Life Cycle (SDLC). SDLC is a process how a software build for live/production. The Process as follows:
  • Requirement Analysis/Planning
  • Design
  • Implementation/Development
  • Testing
  • Evolution/Production
More about SDLC please visit the following link: SDLC Tutorial.