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)