| Author |
Message
|
| manan.patel |
 Posted: Mon Oct 15, 2012 7:28 am Post subject: Want an excell file as Output, need a parser |
 |
|
Apprentice
Joined: 01 Oct 2012
Posts: 25
|
Right now, my message flow is generating a ".csv" file as output, but the ML wants it in excell(.xls) format.
He is not taking my argument to open the file in MS Excel and then convert it into .xls format.
Need only .xls file as output.
So, experts..
Does such parser exist??
Or can we create such parser?? |
|
| Back to top |
|
 |
| lancelotlinc |
| Posted: Mon Oct 15, 2012 7:32 am Post subject: |
|
|
Jedi Knight
Joined: 22 Mar 2010
Posts: 4941
Location: Bloomington, IL USA
|
This is a Message Broker question and belongs in Message Broker forum.
The parser is already available for you to use. Write your code according to the rules you need.
_________________
http://leanpub.com/IIB_Tips_and_Tricks
Save $20: Coupon Code: MQSERIES_READER |
|
| Back to top |
|
|
| mqjeff |
| Posted: Mon Oct 15, 2012 7:37 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
You want to use Broker v8 on Windows and call .NET code to create an Excel file.
There is no other native support for Microsoft Excel documents.
You will have difficulty finding sufficient information from Microsoft about how Excel files are actually formatted in order to actually write your own parser.
Your ML is otherwise being unreasonable. |
|
| Back to top |
|
|
| exerk |
| Posted: Mon Oct 15, 2012 7:47 am Post subject: |
|
|
Jedi Council
Joined: 02 Nov 2006
Posts: 6339
|
Moved to the appropriate forum.
_________________
It's puzzling, I don't think I've ever seen anything quite like this before...and it's hard to soar like an eagle when you're surrounded by turkeys. |
|
| Back to top |
|
|
| lancelotlinc |
| Posted: Mon Oct 15, 2012 7:47 am Post subject: |
|
|
Jedi Knight
Joined: 22 Mar 2010
Posts: 4941
Location: Bloomington, IL USA
|
Excel 2007 uses Office Open XML as its primary file format, an XML-based format that followed after a previous XML-based format called "XML Spreadsheet" ("XMLSS"), first introduced in Excel 2002.
| Code: |
<?xml version="1.0"?>
<Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet"
xmlns:o="urn:schemas-microsoft-com:office:office"
xmlns:x="urn:schemas-microsoft-com:office:excel"
xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet"
xmlns:html="http://www.w3.org/TR/REC-html40">
<Worksheet ss:Name="Sheet1">
<Table ss:ExpandedColumnCount="2" ss:ExpandedRowCount="2" x:FullColumns="1"
x:FullRows="1">
<Row>
<Cell><Data ss:Type="String">Name</Data></Cell>
<Cell><Data ss:Type="String">Example</Data></Cell>
</Row>
<Row>
<Cell><Data ss:Type="String">Value</Data></Cell>
<Cell><Data ss:Type="Number">123</Data></Cell>
</Row>
</Table>
</Worksheet>
</Workbook> |
_________________
http://leanpub.com/IIB_Tips_and_Tricks
Save $20: Coupon Code: MQSERIES_READER |
|
| Back to top |
|
|
| mqjeff |
| Posted: Mon Oct 15, 2012 7:49 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
| I believe that is ".xlsx" not ".xls". |
|
| Back to top |
|
|
| manan.patel |
| Posted: Mon Oct 15, 2012 7:50 am Post subject: |
|
|
Apprentice
Joined: 01 Oct 2012
Posts: 25
|
Thank you all folks for quick response..
And I m very very sorry for posting in wrong forum... |
|
| Back to top |
|
|
| lancelotlinc |
| Posted: Mon Oct 15, 2012 7:50 am Post subject: |
|
|
Jedi Knight
Joined: 22 Mar 2010
Posts: 4941
Location: Bloomington, IL USA
|
| mqjeff wrote: |
| There is no other native support for Microsoft Excel documents. |
WMB supports XML natively using the XMLNSC parser. No other parser is needed to write XLS file format. Beginning with Excel 2002, XLS files are open source, based on Open Office.
_________________
http://leanpub.com/IIB_Tips_and_Tricks
Save $20: Coupon Code: MQSERIES_READER |
|
| Back to top |
|
|
| lancelotlinc |
| Posted: Mon Oct 15, 2012 7:51 am Post subject: |
|
|
Jedi Knight
Joined: 22 Mar 2010
Posts: 4941
Location: Bloomington, IL USA
|
| mqjeff wrote: |
| I believe that is ".xlsx" not ".xls". |
Either way, it opens in Excel with a double-click.
_________________
http://leanpub.com/IIB_Tips_and_Tricks
Save $20: Coupon Code: MQSERIES_READER |
|
| Back to top |
|
|
| Vitor |
| Posted: Mon Oct 15, 2012 7:55 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| 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.
_________________
Honesty is the best policy.
Insanity is the best defence.
Last edited by Vitor on Mon Oct 15, 2012 7:58 am; edited 1 time in total |
|
| Back to top |
|
|
| mqjeff |
| Posted: Mon Oct 15, 2012 7:56 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
| lancelotlinc wrote: |
| mqjeff wrote: |
| I believe that is ".xlsx" not ".xls". |
Either way, it opens in Excel with a double-click. |
there's no indication that manan.patel's ML is using a version of Excel that supports this.
There does appear to be more information available from Microsoft on the Open Office XMl formats than I expected, but I still would use .NET classes instead of trying to build my own XML document.
Particularly at manan.patel's apparent skill level.
And particularly given that it's a reason to push back on the ML to stop being unreasonable. |
|
| Back to top |
|
|
| manan.patel |
| Posted: Mon Oct 15, 2012 8:00 am Post subject: |
|
|
Apprentice
Joined: 01 Oct 2012
Posts: 25
|
hey jedi,
I have a doubt.
Why you have not used <xsd:schema> tag in definition file?? |
|
| Back to top |
|
|
| mqjeff |
| Posted: Mon Oct 15, 2012 8:02 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
| manan.patel wrote: |
| hey jedi, |
"Jedi" is a title not a name.
We call you "manan.patel" since that is your username, not "Novice" which is your title. |
|
| Back to top |
|
|
| manan.patel |
| Posted: Mon Oct 15, 2012 8:03 am Post subject: |
|
|
Apprentice
Joined: 01 Oct 2012
Posts: 25
|
|
| Back to top |
|
|
| lancelotlinc |
| Posted: Mon Oct 15, 2012 8:41 am Post subject: |
|
|
Jedi Knight
Joined: 22 Mar 2010
Posts: 4941
Location: Bloomington, IL USA
|
|
| Back to top |
|
|
|
|
