How to read and write same excel sheet in Jmeter?

Question

I have csv as follows:
url, Expected Reponse, Actual Response, Status

I found various sites explaining how to write to Excel file but can find solution for writing Actual Response to the same file, from where i read.

How do we achieve this?

Answer 1

To update existing file you must write a new file with context.delete old file and rename new file to old file.

In jmeter you can execute java using JSR223 Sampler with language Java.

See java example.