| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Intergration with MS-Excel |
« View previous topic :: View next topic » |
| Author |
Message
|
| ajit1981 |
 Posted: Fri Sep 24, 2010 3:49 am Post subject: Intergration with MS-Excel |
 |
|
Apprentice
Joined: 09 Apr 2010
Posts: 41
Location: Bangalore, Inida
|
Hi,
Isit possibel in Message broker to take the data from MS-Excel ? like there are data stored in 4-5 coulmn in Ms-Excel with multiple rows, We have to add all this data in Database, just wondering weahter WMB support Ms-Excel intergration. I know we can process the .csv file data. But dont know how to process the Excel data ? any clue ?
Thanks in adavance
Ajit |
|
| Back to top |
|
 |
| Vitor |
| Posted: Fri Sep 24, 2010 4:22 am Post subject: Re: Intergration with MS-Excel |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| ajit1981 wrote: |
| any clue ? |
Well the xls file (or in these enlightened times the xlsc) is just that; a file. So in theory you could describe it with a message set and read it. I'm not aware of a pre-generated set (which is not to say there isn't one) but you could reverse engeneer it.
Where I've experienced this it's been the database that was of interest to WMB (business values and rules to control flows; Excel was how the business kept the values straight). Actual Excel files I've processed as csv or as XML inside WMB.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| mqjeff |
| Posted: Fri Sep 24, 2010 4:41 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
You can always read the file as a BLOB and then pass it to a PHPCompute or JavaCompute node that can parse an xlsc/xls file.
You will still have to make effort to map the content to a logical message tree in a format that can be serialized again if you hope to output the data, however.
And I think that xlsc files are actually XML files under the cover, but the structure may not be meaningful in comparison to the business meaning of the document. |
|
| Back to top |
|
|
| ajit1981 |
| Posted: Fri Sep 24, 2010 5:04 am Post subject: |
|
|
Apprentice
Joined: 09 Apr 2010
Posts: 41
Location: Bangalore, Inida
|
Thanks Vitor & mqjeff for sugesstion.
I will with the soultion take file as a blob and then by using the Javacompute node will try to parse that file
thanks again |
|
| 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
|
|
|
|
