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

Performance Testing Process

HP LoadRunner is a Performance Testing Tool. For Performance Testing LoadRunner is widely used. 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.

You can watch the LoadRunner Tutorial video at the link: TUTORIAL VIDEO LINK.

Software Testing Tutorial

Software Download Link

Software Testing is a very high demand in the JOB market. Basically two types of Software Testing i) Manual Testing & Automation Testing. Within this topics I will discuss only Automation Testing. Automation testing also two types: i) Functional Testing & ii) Performance Testing.

Functional Testing:

For functional testing there are many testing tool in the market but widely used HP UFT/QTP & Selenium. HP UFT/QTP is a paid licensed tool & selenium is open source. Also you can use UFT for 30 days trial version. DOWNLOAD LINK.

Selenium is a free tool. It’s support lot of language such as Java, PHP, Pearl, Ruby, Python etc. You can download selenium at the following link: DOWNLOAD LINK

Performance Testing:

Also for performance Testing there are many tool in the market but HP LoadRunner & Apache JMeter are widely used. HP LoadRunner is paid licensed tool but you can use trial version for 30 days. You can download LoadRunner at the following link: DOWNLOAD LINK

Apache JMeter is a free opensource tool but now a days it’s getting popular. You can download JMeter at the following link: DOWNLOAD LINK