Service Virtualization

Hi Everyone,

Can you guide me how to write the actual response to a particular row/column to an excel sheet.

Can you send me code to id: mailtojai2004@yahoo.co.in

Thanks

Hi Jai,

I too encountered same issue and came across Apache POI Jars. Scripts are easily available on internet you just need to mount your input file and required excel file index (Row,column) within script . Please refer below threads .

Writing Response to Excel File - LOG Utility 

Read Write From Excel File 

Don't forget to include the libs. 

Cheers !

Hi folks,

While implementing something for a customer, I came across this relatively new free library:

https://codoid.com/fillo/

It's a wrapper around Apache POI that allows you to execute Select, Insert, Update, and Delete against an Excel workbook using SQL notation.  It hides all the complexity that comes with the raw POI API.  Does this help?

--Mike

This makes me very happy. I've been waiting for someone to make a usable free Excel-as-SQL jar utility forever!

JOIN is not yet supported but, yeah, this question comes up a lot - especially the ability to write to Excel.

--Mike