This is the mail archive of the
xsl-list@mulberrytech.com
mailing list .
RE: xml 2 csv
- From: "Jan Weiss" <jweiss at bct-technology dot com>
- To: "xsl-list" <xsl-list at lists dot mulberrytech dot com>
- Date: Fri, 16 Nov 2001 14:19:09 +0100
- Subject: RE: [xsl] xml 2 csv
- Reply-to: xsl-list at lists dot mulberrytech dot com
and how am i able to get an output for each line:
at the moment, all the data appears in one line.
another question:
i am using jakarta-tomcat which sends the data to my browser. now i want
excel to open when i send the csv data. is this possible? with pdf it works
(to open acrobat) without any problem.
here is my xsl:
<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
version="1.0" xmlns:saxon="http://icl.com/saxon"
extension-element-prefixes="saxon">
<xsl:param name="lang">en</xsl:param>
<xsl:output method="text"/>
<xsl:template match="/">
<xsl:apply-templates/>
</xsl:template>
<xsl:template match="sdmc-article-list">
<xsl:apply-templates/>
</xsl:template>
<xsl:template match="results">
<xsl:for-each select="row"> <!--these 4 attributes should be in one
line -->
<xsl:value-of select="@nrl"/>; <!-- next row in the next one -->
<xsl:value-of select="@bla"/>;
<xsl:value-of select="@nth"/>;
<xsl:value-of select="@klj"/>;
</xsl:for-each>
</xsl:template>
</xsl:stylesheet>
-----Original Message-----
From: owner-xsl-list@lists.mulberrytech.com
[mailto:owner-xsl-list@lists.mulberrytech.com]On Behalf Of Michael Kay
Sent: Freitag, 16. November 2001 11:38
To: xsl-list@lists.mulberrytech.com
Subject: RE: [xsl] xml 2 csv
> i am transforming xml into three output formats: html, pdf and xml
>
> now i would like to know, if it is also possible to transform
> xml into csv
> files
> so i can view it with microsoft excel in my browser??
> if it is, what do i need to use and is there a reference
>
Just use <xsl:output method="text"/>, and be very careful about controlling
the output of whitespace.
Mike Kay
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list