webMetods flow services

, ,
1

Hi,

Can anyone please help me to understand how to create Excel sheet in webMethods?. exporting data to excel files using flow service perhaps from oracle database.

2

Hi Stanley,

unfortunately this is not available ootb.

You will have to write some java services by using an office API like i.e. POI from Apache to get access to the excel file formats.

For connecting to Oracle Database you can use JDBC Adapter and Oracle Thin Driver available from OTN (Oracle Tech Net).

Regards,
Holger

3

If you just need the .csv file, you can create a flat file schema/dico and map the output of the adatper service or refer the below code that I published in the past, hope it helps.

http://techcommunity.softwareag.com/web/guest/pwiki/-/wiki/Main/Java+Service+to+convert+StringList+and+DocList+to+XLS+-+ToExcel+Utility?_36_redirect=http%3A%2F%2Ftechcommunity.softwareag.com%2Fpwiki%2F-%2Fwiki%2FMain%2Forphan_pages%3F_36_advancedSearch%3Dfalse%26_36_orderByType%3D%26p_r_p_185834411_title%3DNatural%2BArticles%26_36_keywords%3D%26_36_orderByCol%3D%26_36_delta%3D5%26p_r_p_564233524_resetCur%3Dfalse%26_36_cur%3D88%26_36_andOperator%3Dtrue

1 Like