| Author |
Message
|
| ak |
 Posted: Tue May 01, 2007 3:15 am Post subject: Reading Microsoft Excel into WMB |
 |
|
Apprentice
Joined: 07 Aug 2006
Posts: 48
Location: England
|
Folks
Does anyone know if reading and processing MS Excel spreadsheets is possible? If so are there any support pacs? or Java User defined input nodes doing this already? |
|
| Back to top |
|
 |
| Vitor |
| Posted: Tue May 01, 2007 3:30 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
At the simplist, it's just a file. You can put them in as MQFMT_NONE
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| Michael Dag |
| Posted: Tue May 01, 2007 3:47 am Post subject: |
|
|
Jedi Knight
Joined: 13 Jun 2002
Posts: 2607
Location: The Netherlands (Amsterdam)
|
.xls will be difficult with WMB , saving the Excel spreadsheet as XML (with Office 2003) should make it easier...
_________________
Michael
MQSystems Facebook page |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Tue May 01, 2007 3:50 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
Or as a CSV file that can then be parsed with TDS...
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| Vitor |
| Posted: Tue May 01, 2007 3:51 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
Or (if you're on a back version of Office) as a .csv
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| ak |
| Posted: Tue May 01, 2007 4:46 am Post subject: Reading Microsoft Excel into WMB |
|
|
Apprentice
Joined: 07 Aug 2006
Posts: 48
Location: England
|
Sorry guys
I was really looking at automating the reading of the Excel spreadsheet, I have seen previous threads discussing reading PDF files or writting an MRM for PDF files. I thought someone somewhere has tried doing a similar thing for Excel especially that there seem to be loads of Java classes on the web doing just that. |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Tue May 01, 2007 5:07 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
I'm sure someone probably has done this. I'm not aware of any particular solutions, though. But then again, I haven't particularly looked for any solutions, either.
If you decide to do this yourself, the simplest way is probably to put the .xls file on a queue as a MQFMT_NONE message, read it with an MQInput node set to BLOB and then use a JavaComputeNode to pass the bitstream to the java classes you've found.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| PieterV |
| Posted: Wed Jun 06, 2007 6:08 am Post subject: Re: Reading Microsoft Excel into WMB |
|
|
Disciple
Joined: 04 Jan 2006
Posts: 164
Location: Belgium
|
| ak wrote: |
| . I thought someone somewhere has tried doing a similar thing for Excel especially that there seem to be loads of Java classes on the web doing just that. |
Could anybody point me to that place on the web where i can find Java Classes to convert XLS? |
|
| Back to top |
|
|
| wschutz |
| Posted: Wed Jun 06, 2007 9:52 am Post subject: Re: Reading Microsoft Excel into WMB |
|
|
Jedi Knight
Joined: 02 Jun 2005
Posts: 3316
Location: IBM (retired)
|
| PieterV wrote: |
| ak wrote: |
| . I thought someone somewhere has tried doing a similar thing for Excel especially that there seem to be loads of Java classes on the web doing just that. |
Could anybody point me to that place on the web where i can find Java Classes to convert XLS? |
Yes, try "google.com".
_________________
-wayne |
|
| Back to top |
|
|
| marcin.kasinski |
| Posted: Wed Jun 06, 2007 9:59 am Post subject: Re: Reading Microsoft Excel into WMB |
|
|
Sentinel
Joined: 21 Dec 2004
Posts: 850
Location: Poland / Warsaw
|
You can try jakarta poi (http://jakarta.apache.org/poi/) in your JAVA Compute node.
_________________
Marcin |
|
| Back to top |
|
|
| ramires |
| Posted: Wed Jun 06, 2007 2:03 pm Post subject: |
|
|
Knight
Joined: 24 Jun 2001
Posts: 523
Location: Portugal - Lisboa
|
you can define a xls file as an ODBC data source, and then from MB access that data source... well I never tried that and may have limitations
Regards
Joao Ramires |
|
| Back to top |
|
|
|
|
