| Author |
Message
|
| sandip_gaikwad |
 Posted: Tue Jul 26, 2011 1:10 am Post subject: conversion of xls file to xml in message broker |
 |
|
Voyager
Joined: 25 Jul 2011
Posts: 95
|
how to covert xls file into xml file in messahe broker plz give usefule sample link and usefule data  |
|
| Back to top |
|
 |
| WMBDEV1 |
| Posted: Tue Jul 26, 2011 1:28 am Post subject: |
|
|
Sentinel
Joined: 05 Mar 2009
Posts: 888
Location: UK
|
What have you tried so far?
First you'll need to understand the XLS format. What research have you dont into this?
If it were me i'd use something like the POI project from Apache.
And dont double post, that will just annoy people. |
|
| Back to top |
|
|
| sandip_gaikwad |
| Posted: Tue Jul 26, 2011 1:35 am Post subject: |
|
|
Voyager
Joined: 25 Jul 2011
Posts: 95
|
| actually my confusion is that i m not able to know to set the delimiter or repeated delimiter property as such no specific format is there...?? pls help.. |
|
| Back to top |
|
|
| Aldrine |
| Posted: Tue Jul 26, 2011 3:38 am Post subject: Java Excel API - jexcelapi |
|
|
Novice
Joined: 25 Jul 2011
Posts: 22
Location: India
|
| sandip_gaikwad wrote: |
| actually my confusion is that i m not able to know to set the delimiter or repeated delimiter property as such no specific format is there...?? pls help.. |
I suggest you look into
http://jexcelapi.sourceforge.net/
It is a Jave package for xls. Incoporate it into Java Compute Node.[/url]
_________________
--
Aldrine Einsteen |
|
| Back to top |
|
|
| sandip_gaikwad |
| Posted: Tue Jul 26, 2011 4:09 am Post subject: |
|
|
Voyager
Joined: 25 Jul 2011
Posts: 95
|
| thanx for your reply... but i want to do it through message broker.... pls reply as soon as possible... |
|
| Back to top |
|
|
| Aldrine |
| Posted: Tue Jul 26, 2011 4:21 am Post subject: |
|
|
Novice
Joined: 25 Jul 2011
Posts: 22
Location: India
|
| sandip_gaikwad wrote: |
| thanx for your reply... but i want to do it through message broker.... pls reply as soon as possible... |
Could give me some more information by what you mean as Through Message Broker? As utilizing a java Class would be still through Java Compute Node of WMB!
_________________
--
Aldrine Einsteen |
|
| Back to top |
|
|
| marko.pitkanen |
| Posted: Tue Jul 26, 2011 4:21 am Post subject: |
|
|
Chevalier
Joined: 23 Jul 2008
Posts: 440
Location: Jamsa, Finland
|
Hi,
Do you want to process Microsoft Excel file and convert it's content to xml structure?
I'm afraid of that you can't do it through message set. You perhaps need to use java -compute node and some external libraries to do the magic --like the others have earlier advised.
--
Marko |
|
| Back to top |
|
|
| sandip_gaikwad |
| Posted: Tue Jul 26, 2011 4:24 am Post subject: |
|
|
Voyager
Joined: 25 Jul 2011
Posts: 95
|
| i dont have much knowledge about java... can we do with esql... if not then can u pls guide me in doing it through java compute node... |
|
| Back to top |
|
|
| sandip_gaikwad |
| Posted: Tue Jul 26, 2011 4:28 am Post subject: |
|
|
Voyager
Joined: 25 Jul 2011
Posts: 95
|
hi marco,
yes i want to convert microsoft excel file to text file... which libraries i need to incorporate.... or could u pls provide me with sample java code... |
|
| Back to top |
|
|
| mqjeff |
| Posted: Tue Jul 26, 2011 4:45 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
| export the XLS files as a CSV file, and then use a TDS message set to model it. |
|
| Back to top |
|
|
| kimbert |
| Posted: Tue Jul 26, 2011 9:36 am Post subject: |
|
|
Jedi Council
Joined: 29 Jul 2003
Posts: 5542
Location: Southampton
|
You should explain your requirement more clearly. Most people are assuming that you want to convert a .xls file to XML. I think you want to convert a comma-separated file to XML, based on this comment that you made in one of your posts: "actually my confusion is that i m not able to know to set the delimiter or repeated delimiter property as such no specific format is there.".
If I am correct, then you simply need to look at the CSV sample in the Samples Gallery. |
|
| Back to top |
|
|
| sandip_gaikwad |
| Posted: Tue Jul 26, 2011 8:57 pm Post subject: |
|
|
Voyager
Joined: 25 Jul 2011
Posts: 95
|
| i have done csv to xml but my problem is i dont want to convert xls file to csv.... instead directly an xls file to xml.... pls help... |
|
| Back to top |
|
|
| Aldrine |
| Posted: Tue Jul 26, 2011 9:08 pm Post subject: |
|
|
Novice
Joined: 25 Jul 2011
Posts: 22
Location: India
|
@Sandip: There is no inherent option in WMB to convert xls to xml.
MY suggestion is to use a third party class to read anc convert the Excel entries into XML nodes using a DOM document Builder.
If you are using ESQL; i suggest u get a static method to do the above functionality and get the results as text over to ESQL.
As i previously suggested take a look at jexcelapi. It is quite simple.
Using it you can read the xls file and strip the data and If you have a java coder at your disposal ask him to convert the xls into xml using a DOM builder.
--
Aldrine Einsteen
Asking the same Question again and again doesn't make you look witty!
Just the contrary... |
|
| Back to top |
|
|
| j.f.sorge |
| Posted: Wed Jul 27, 2011 8:13 am Post subject: |
|
|
Master
Joined: 27 Feb 2008
Posts: 218
|
Maybe your question will be answered here
_________________
IBM Certified Solution Designer - WebSphere MQ V6.0
IBM Certified Solution Developer - WebSphere Message Broker V6.0
IBM Certified Solution Developer - WebSphere Message Broker V6.1
IBM Certified Solution Developer - WebSphere Message Broker V7.0 |
|
| Back to top |
|
|
| sandip_gaikwad |
| Posted: Fri Jul 29, 2011 10:14 pm Post subject: |
|
|
Voyager
Joined: 25 Jul 2011
Posts: 95
|
| please give me some useful link and hands on on the same the given link is not useful. |
|
| Back to top |
|
|
|
|
