MQSeries.net :: View topic - Using File Input Node with Excel Spreadsheet

MQSeries.net

Tech Exchange

Education

Certifications

Library

Info Center

SupportPacs

FAQÂ Â

Usergroups

RSS Feed - WebSphere MQ Support

RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Using File Input Node with Excel Spreadsheet

Using File Input Node with Excel Spreadsheet

« View previous topic :: View next topic »

Author

Message

gerardmaj

Posted: Tue Sep 16, 2008 11:47 pm Post subject: Using File Input Node with Excel Spreadsheet

Newbie

Joined: 16 Sep 2008
Posts: 9

Hello, Can someone tell me if it is possible to read int data from an Excel spreadsheet into a WMB (v6.1) message flow? If so can I use the MRM Message Domain and create a message set based on either TDS or CWF? Thanks

yaakovd

Posted: Thu Sep 18, 2008 11:01 pm Post subject:

Partisan

Joined: 20 Jan 2003
Posts: 319
Location: Israel

You can do it using one of following options:

1. save xls file as csv. then you will able to read comma-delimited file using simple TDS.

2. create your own Java node for reading and conversion of file.
_________________
Best regards.
Yaakov
SWG, IBM Commerce, Israel

gerardmaj

Posted: Thu Sep 18, 2008 11:42 pm Post subject:

Newbie

Joined: 16 Sep 2008
Posts: 9

Thanks for that. Do you have any experience of using the JExcelAPI in a JavaCompute Node?

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Using File Input Node with Excel Spreadsheet

Jump to:

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

Protected by Anti-Spam ACP