Thanks for the information. But i am not able to write it to excel. I use the below code for read from excel and set it in the sopaui property.
----------------
import org.apache.poi.hssf.usermodel.*;
dFormatter = new HSSFDataFormatter()
srcBook = new HSSFWorkbook(new FileInputStream(new File("...\\TestData.xls")))
fEval = new HSSFFormulaEvaluator(srcBook)
sourceSheet = srcBook.getSheetAt(0)
context.rowCounter = 0
sourceRow = sourceSheet.getRow(0)
elNameCell = sourceRow.getCell(0)
testCase.setPropertyValue("ElName",dFormatter.formatCellValue(elNameCell,fEval))
-----------
after execution, i am not able to write the executed request and response into the same excel file and inturn into the last column of same row. Could you please help me with the code?. I would appreciate if i get the full code for writing.
