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,
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.
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
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