Hi there,

I’m new in web methods world.

I need to know if it’s possible to receive an excel spreadsheet sent via email (Microsoft exchange server) in Trading Networks. According to TN user Guide, “Trading Networks supports TN document types for two categories of
documents: XML documents and flat file documents.”

Regards
Mathapelo Malema

Mathapelo,

Search in this form how to handle excel (.xls)files in IS/TN there are some discussions held on this problem/resolution etc. you will find some positive responses.

I believe there is some thirdparty utility or package needs to install to accomplish this task.

Ofcourse .csv flatfiles can be default handled by WM IS/TN.

HTH,
RMG

Check out

Java Excel API - A Java API to read, write, and modify Excel spreadsheets
[url=“http://jexcelapi.sourceforge.net/”]http://jexcelapi.sourceforge.net/[/url]

It is defenately possible to handle Excel documents in TN via e-mail or HTTP/FTP it just matter of what format you need to work with them.
If you search shareware section you will find a number of packages dealing with Excel data like content handlers for IS to read Excel files using Apache POI HSSF open source API. If you have a specific use case send me e-mail for discussion.

Hi All,

Thank you all for your help. I searched the shareware and found number of alternative solutions to my project.

Just a follow-up question; If POP3 in not enabled, Is there another method that one can use to receive email via microsoft exchange server?

Thanking you in advance