read data from jmeter results and write it into an excel file.

[hrishab]

hello,
iam doing a load testing in jmeter and i want a way through which i can copy the
"request" and "response data" from the test results to an excel file

thanks in advance
venki

[Bnt]

Hi

Have a look at a java excel library like http://www.andykhan.com/jexcelapi/, which will provide functionality to write the data out to excel.

OR use one of these methods posted by cjard previously

why not connect to the DB using JDBC, then list the data into a text file with a .csv extension.. in comma separated format. access willload it easily then your other option, if you wish to avoid jexcelapi, is to make an ODBC connection to the excel file and write to it as though it were a database

Byron

[cjard]

or, if you cant understand my fast and loose typing:

write the data to a file with a .csv extension and separate each data with commas:

machine_id,litres,hours,efficiency
01,5,2,0.78
02,4,2,0.99
03,7,3,0.66



access will load this into tabular representation


or, you can read and write excel files with SQL, if you make an odbc connection to the excel file, then make an JDBC conenction to the odbc connection(jdbc odbc bridge adapter).. i dont know what the sql looks like, but youre bound to find some on the web..
maybe:
INSERT INTO Workbook1.Sheet1 VALUES (5,2,1,4)

not quite this, but it's something like it. ask in the database section of this site..

[glinius]

You can "tell" JMeter to store request and response data into a CSV file which can be opened in Excel or equivalent after the test. To do so locate "user.properties" file (it lives under /bin folder of your JMeter installation) and add the following properties:

jmeter.save.saveservice.output_format=csv
jmeter.save.saveservice.samplerData=true
jmeter.save.saveservice.response_data=true

Note that the properties change is not dynamic, JMeter restart will be required to pick them up. After change run your .jmx script as follows:

jmeter -n -t /path/to/your/test.jmx -l /path/to/results/test.csv

The command above will execute the test and store results into test.csv file which can later be opened via Excel or similar application like LibreOffice Calc.

See Apache JMeter Properties Customization Guide for more details on different JMeter properties and their customization approaches.