[XSL-LIST Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message]

RE: stylesheet to writing to excel

Subject: RE: stylesheet to writing to excel
From: STEPHEN_R_FRIEDLAND@xxxxxxxxx
Date: Tue, 26 Mar 2002 14:09:06 -0500
style sheet excel
Actually, after searching for info for a while, I discovered it's pretty
straightforward. Excel will read csv, tab-separated, or html. Create a 
style sheet to output any of these will work. I chose to output tab-
separated through a servlet. The piece I was stuck on for a while was how to
output tabs and newlines. The following variables were what I needed.

<xsl:variable name="newline">
  <xsl:text>&#10;</xsl:text>
</xsl:variable>
<xsl:variable name="tab">
  <xsl:text>&#9;</xsl:text>
</xsl:variable>

Separate each element with <xsl:value-of select="$tab"/> and end each row
with <xsl:value-of select="$newline"/>. If you are streaming it to a browser
you have to also set the content type.

HTH,
-Steve

-----Original Message-----
 I was wondering whether anyone knows where I can find tutorials for 
writing stylesheet for excel applications (i.e. transform an xml to a excel 
document), if possible can somebody tell me where i could find such 
information

 XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list


Current Thread

PURCHASE STYLUS STUDIO ONLINE TODAY!

Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced!

Buy Stylus Studio Now

Download The World's Best XML IDE!

Accelerate XML development with our award-winning XML IDE - Download a free trial today!

Don't miss another message! Subscribe to this list today.
Email
First Name
Last Name
Company
Subscribe in XML format
RSS 2.0
Atom 0.3
Site Map | Privacy Policy | Terms of Use | Trademarks
Free Stylus Studio XML Training:
W3C Member
Stylus Studio® and DataDirect XQuery ™are products from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2013 All Rights Reserved.