Join this online group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.
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)