Document list to excel in webmethods

Hello team, i have a requirement to create a excel from documentlist. I need to take care of color as well. Any idea how we can achieve this?

1 Like

The common approach is to add the Apache POI Java library to your package and wrap it from Java services

https://poi.apache.org/components/spreadsheet/index.html
https://poi.apache.org/components/spreadsheet/quick-guide.html

https://documentation.softwareag.com/webmethods/microservices_container/msc10-11/10-11_MSC_PIE_webhelp/index.html#page/integration-server-integrated-webhelp%2Fesb.java.html

1 Like