cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Marcelo F. Ochoa" <>
Subject RE: XML to EXCEL???? (output)
Date Thu, 06 Jul 2000 11:48:53 GMT

Hi, guys
I have a very simple question:
Is there any parser or processor that can transform an XML page to an
Excel file and/or viceversa.
[>]  To generates an excel output there is a simple trick.
Add to this lines:
formatter.type.application/ = org.apache.cocoon.formatter.TextFormatter
[>]  # Excel Formatter
formatter.application/ = application/
[>]  Then, if you have a XML like this:
<?xml version="1.0"?>
<?xml-stylesheet href="http://server:port/xsl/excel.xsl" type="text/xsl"?>
<?cocoon-process type="xslt"?>
<name id="Bunny Boot">
<name id="Ace Ski Boot">
<!-- Author: Marcelo F. Ochoa "" -->

where excel.xsl is a simple stylesheet which add <tab> between cols and <cr> after
each row, ej:
<?xml version="1.0"?>

<!-- Written by Marcelo F. Ochoa "" -->

<xsl:stylesheet xmlns:xsl="">

  <xsl:template match="/">
   <xsl:processing-instruction name="cocoon-format">type="application/"</xsl:processing-instruction>
           <xsl:for-each select="sales/name">
                <xsl:sort select="point"
                <xsl:value-of select="@id"/><xsl:text>	</xsl:text>
                <xsl:value-of select="city"/><xsl:text>	</xsl:text>
                <xsl:value-of select="point"/><xsl:text>	</xsl:text>
                <xsl:value-of select="stock"/><xsl:text>	</xsl:text>


And that's all....  
I have to design a new system and I'll really like to use Cocoon but
also I want to add a new feature like this.
I looked for it in the Microsoft's page, but they just have this very
expensive BizTalk Server or something  like that can do this kind of
work, but I would like to find an open source tool !!!

Thanks for your help

Computers let you make More mistakes faster
than any other invention in human history
with the possible exception of handguns and tequila.

cArLos  8-)

[>]  Reagards, Marcelo. 
PD: Excel to XML is another history.
View raw message