ASG
IBM
Zystems
Cressida
Icon
Netflexity
 
  MQSeries.net
Search  Search       Tech Exchange      Education      Certifications      Library      Info Center      SupportPacs      LinkedIn  Search  Search                                                                   FAQ  FAQ   Usergroups  Usergroups
 
Register  ::  Log in Log in to check your private messages
 
RSS Feed - WebSphere MQ Support RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Want an excell file as Output, need a parser

Post new topic  Reply to topic Goto page Previous  1, 2
 Want an excell file as Output, need a parser « View previous topic :: View next topic » 
Author Message
lancelotlinc
PostPosted: Mon Oct 15, 2012 8:48 am    Post subject: Reply with quote

Jedi Knight

Joined: 22 Mar 2010
Posts: 4941
Location: Bloomington, IL USA

Vitor wrote:
lancelotlinc wrote:
mqjeff wrote:
I believe that is ".xlsx" not ".xls".


Either way, it opens in Excel with a double-click.


Not if the OP's client is using a version of Excel before they adopted that standard.

And yes, in the real world Office 2003 is still widely used. I'm looking at it now, and yes other parts of the same organization are using Office 2007.

Everyone is still also on XP despite the Win7 rollout being timetabled for January 2012.

We have servers on XP, 2003, 2008 & IMHO it's a miracle none of them are NT4.

And the client's OP is being unreasonable asking for application code in a Microsoft proprietory format.


Good points, Sir Vitor. People who use ten year old software get what they pay for. I like IBM's policy of sunsetting WMB software products and tools after five years of life.
_________________
http://leanpub.com/IIB_Tips_and_Tricks
Save $20: Coupon Code: MQSERIES_READER
Back to top
View user's profile Send private message Send e-mail
Vitor
PostPosted: Mon Oct 15, 2012 9:00 am    Post subject: Reply with quote

Grand High Poobah

Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA

lancelotlinc wrote:
People who use ten year old software get what they pay for.


And in this case, they're paying for a native format Excel 2003 file. Are they paying enough? That's the question.

lancelotlinc wrote:
I like IBM's policy of sunsetting WMB software products and tools after five years of life.


Whereas Microsoft software products have no life in the first place, but just lurch round your desktop.
_________________
Honesty is the best policy.
Insanity is the best defence.
Back to top
View user's profile Send private message
lancelotlinc
PostPosted: Mon Oct 15, 2012 9:33 am    Post subject: Reply with quote

Jedi Knight

Joined: 22 Mar 2010
Posts: 4941
Location: Bloomington, IL USA

Vitor wrote:
Whereas Microsoft software products have no life in the first place, but just lurch round your desktop.


Ow. Reminds me of Shaq's ad: I have shoes bigger than some hybrids ... and more stylish too [as he puts his finger in your eye]. Ow!
_________________
http://leanpub.com/IIB_Tips_and_Tricks
Save $20: Coupon Code: MQSERIES_READER
Back to top
View user's profile Send private message Send e-mail
mgk
PostPosted: Mon Oct 15, 2012 7:01 pm    Post subject: Reply with quote

Padawan

Joined: 31 Jul 2003
Posts: 1642

In case it helps, there is a four part developer works tutorial on using the .NET Compute node here:

http://www.ibm.com/developerworks/websphere/tutorials/1112_thompson/index.html

And part 3 shows how to use the OpenXML .NET SDK to manipulate an Excel spreadsheet:

http://www.ibm.com/developerworks/websphere/tutorials/1202_thompson3/index.html


Kind Regards,
_________________
MGK
The postings I make on this site are my own and don't necessarily represent IBM's positions, strategies or opinions.
Back to top
View user's profile Send private message
darioo
PostPosted: Thu Oct 25, 2012 2:43 am    Post subject: Reply with quote

Novice

Joined: 19 Mar 2009
Posts: 15

One more possibility that you can consider, IF you have Java knowledge and/or cannot use MB8 on Windows for its .NET capabilities, is using Apache POI inside a JavaCompute node:

http://poi.apache.org/

It can be used to create a valid .xls file based on your input, and then output it wherever you want to using WMB's standard facilities.

POI is a pure Java library, so it can be used on any OS that supports Java. Creating .xls files on an AIX machine is cool
Back to top
View user's profile Send private message
mqjeff
PostPosted: Thu Oct 25, 2012 4:06 am    Post subject: Reply with quote

Grand Master

Joined: 25 Jun 2008
Posts: 17447

darioo wrote:
Creating .xls files on an AIX machine is cool

Designing business processes that don't rely on "spreadsheets" is cooler...
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic  Reply to topic Goto page Previous  1, 2 Page 2 of 2

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Want an excell file as Output, need a parser
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
 
 


Theme by Dustin Baccetti
Powered by phpBB © 2001, 2002 phpBB Group

Copyright © MQSeries.net. All rights reserved.