Hi Folks,
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.
TIA
Regards
Rahul V
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.
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.
Regards
Rahul V
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.
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