| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Reading the EXCEL using JAVA compute node |
« View previous topic :: View next topic » |
| Author |
Message
|
| vijaychand |
 Posted: Tue Nov 29, 2011 1:10 am Post subject: Reading the EXCEL using JAVA compute node |
 |
|
Novice
Joined: 29 Nov 2011
Posts: 12
|
hi all,
can any one please help me .
how to read an EXCEL using Java Compute node . |
|
| Back to top |
|
 |
| kimbert |
| Posted: Tue Nov 29, 2011 1:50 am Post subject: |
|
|
Jedi Council
Joined: 29 Jul 2003
Posts: 5542
Location: Southampton
|
Do you want to
a) read a CSV file exported from an Excel spreadsheet or
b) read a .xls file?
If a) then use the CSV sample in the Samples Gallery as your starting point.
If b), you will need to use a JavaCompute node and find a library that can read .xls files.
Or, if on Windows, wait for v8 and use the .NET support  |
|
| Back to top |
|
|
| vijaychand |
| Posted: Tue Nov 29, 2011 2:59 am Post subject: |
|
|
Novice
Joined: 29 Nov 2011
Posts: 12
|
i wanted to read .xls file only .
and convert it into XML format . |
|
| Back to top |
|
|
| kimbert |
| Posted: Tue Nov 29, 2011 3:19 am Post subject: |
|
|
Jedi Council
Joined: 29 Jul 2003
Posts: 5542
Location: Southampton
|
1. Find a Java class library that can read .xls files. Google will help you to do that.
2. Write some Java code in a JavaCompute node. The code will parse the .xls using the class library, and create the message tree using some code that you write yourself.
You were probably hoping that somebody else had solved this problem already, and published a support pack. I don't blame you asking, but I don't know of any such support pack. Maybe there's an opportunity for you?
btw, I still believe what I wrote in this thread: http://www.mqseries.net/phpBB2/viewtopic.php?t=55686 |
|
| Back to top |
|
|
| vijaychand |
| Posted: Tue Nov 29, 2011 3:40 am Post subject: |
|
|
Novice
Joined: 29 Nov 2011
Posts: 12
|
Thanks .. i will look into that ..
Thanks for your Help. |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
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
|
|
|
|
