Hi All,

I am trying to generate the excel using Java Service. For this i have placed the POI java library on the following path on the server /Integration Server/lib/jars as well as referenced the same on the designer.

I have configured the Input/Output parameters as follows

Input:
------

Employee - Document List
Name - String
Designation - String
Department - String

Output:
-------

ExcelObject (Object) - I am not aware how to map the excel OLE object to the excel object.


I also tried with another option to create the excel file on the project folder say "Employee.xls". For this i have removed the output parameter and executed the java service on the designer and i don't see any error or any generated file.

It seems the debug trace as well System.out.println() will not work for java service.

Can any body help me out to resolve this issues or any input or suggestions to make it work.

Try these:

http://idnxchange.com/forum/https-ftp-smtpn/199-how-to-export-data-into-excel-sheet-using-webmethods-flow-service.html

http://idnxchange.com/webmethods-blogs/step-by-step-procedure-for-building-excel-client-using-developer.html

Hope these will help you out