Java Service to convert StringList and DocList to XLS - ToExcel Utility

Hi All,

Attached is the java utility service that will convert StringList/DocList/StringTable to XLS and the same can be saved or emailed. 

Note: The service uses "poi-4.1.0.jar" and it is embedded in the IS package, the code has been tested on IS 10.4 with JDK 1.8.0_201 (52.0)

By default the file gets saved at the location "C:\SAG_Home\IntegrationServer" and this can be overridden by specifying the input file path "file_name" in the core java services:

ToExcel.util:docListToMSExcel
ToExcel.util:stringListToMSExcel


ToExcel.helper:stringTableToDocList (helper service to convert StringTable to DocList)

Refer to the below demo services and contact me if you have any questions.

ToExcel.demo:docListToExcel
ToExcel.demo:stringListToExcel
ToExcel.demo:stringTableToExcel

Thanks,

Mahesh K Sreenivasulu

ToExcel.zip (2.44 MB)