I am building one utility that will take request XML from Excel file through data set and will hit the service deployed on VSE.
I want the response to be written in Same excel file in cell next to request XML.
How can we write to Excel file in LISA.
I am using LISA 6.0.
I don't have any ready samples to show you but you can do this with Apache POI. You can write this code in a Java Script step within your test case. You may be able to find other examples on this forum on through a google search.
HSSF and XSSF Examples
Thanks a ton Josh.
Went through Apache POI on google.
Looks like some jar files need to be imported in LISA for Apache POI and a bit of code to workout on workbook(Excel) will help.
No problem. And to add the product does ship with the POI classes so you should be able to begin writing scripts immediately without adding any additional jars.