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

RE: Re: RE: Producing Excel 2000 htm files: how do I

Subject: RE: Re: RE: Producing Excel 2000 htm files: how do I manage the hidden stuff
From: cknell@xxxxxxxxxx
Date: Tue, 02 May 2006 14:06:14 -0400
excel 2000 xml format
I would be only too happy to, if one were available. When I open an Excel file and choose File->Save As from the drop-down menu, I am presented with the following 31 format choices, none of which is XML:

Microsoft Excel Workbook (*.xls)
Web Page (*.htm;*.html)
Template (*.xlt)
Text(Tab elimitted)(*.txt)
Unicode Text (*.txt)
Microsoft Excel 5.0/95 Workbook (*.xls)
Microsoft Excel 97-2000 & 5.0/95 Workbook (*.xls)
CSV (Comma delimitted)(*.csv)
Microsoft Excel 4.0 Worksheet (*.xls)
Microsoft Excel 3.0 Worksheet (*.xls)
Microsoft Excel 2.1 Worksheet (*.xls)
Microsoft Excel 4.0 Workbook (*.xlw)
WK4 (1-2-3)(*.wk4)
WK3,FM3 (1-2-3)(*.wk3)
WK3 (1-2-3)(*.wk3)
WK1,FMT(*.wk1)
WK1,All(*.wk1)
WK1(*.wk1)
WKS (*.wks)
WQ1 (Quattro Pro/DOS) (*.wq1)
DBF 4 (dBase IV)
DBF 3 (dbase III)
DBF 2 (dbase II)
Formatted Text (Space delmitted)(*.prn)
Text Macintosh (*.txt)
Text DOS (*.txt)
CSV Macintosh (*.csv)
CSV DOS (*.csv)
DIF (Data interchange format)(*.dif)
SYLK (Symbolic link)(*.slk)
Microsoft Excel Add-In (*.xla)

My version information for Excel says "9.0.06926-SP3". Which one of the file types enumerated in the list above gives me an XML file?
-- 
Charles Knell
cknell@xxxxxxxxxx - email



-----Original Message-----
From:     Jon Gorman <jonathan.gorman@xxxxxxxxx>
Sent:     Tue, 2 May 2006 12:39:06 -0500
To:       xsl-list@xxxxxxxxxxxxxxxxxxxxxx
Subject:  Re: RE:  Producing Excel 2000 htm files: how do I manage the hidden stuff

On 5/2/06, cknell@xxxxxxxxxx <cknell@xxxxxxxxxx> wrote:
> The direct answer is, "Because I didn't think of it." Having now tried it, I can tell you that it strips away all the XML markup from the document, leaving only the element contents.

It creates an comment, just like xsl:element.  The content of the
comment are determined by what the xsl:comment element contains. 
Remember that a comment doesn't contain markup (since it is after all,
just text).  So when you have a element somewhere in the template, it
returns just the text value.  (Just as if you evaluated an element as
a string elsewhere in XSLT).

If you want to complate the sin of inserting functionality in a
non-functional part of the xml document, you'll need to tell it what
text you want to output (ie the "looks like markup" but is not).

So one possible way of doing this would be something like:

 <xsl:template match="*" mode="insideComment">
     <xsl:text><</xsl:text><xsl:value-of select="name(.)"
/><xsl:text>></xsl:text>
<xsl:apply-templates />
<xsl:text></</xsl:text><xsl:value-of select="name(.)"
/><xsl:text>></xsl:text>
   </xsl:template>



Of course, I wonder more:
1) Why not just do it in the Excel xml format if your target is Excel
2000.  I thought that was more well supported and documented for the
2000 version?

2) Why not use some other XML techniques (SAX or DOM) or libraries in
conjunction with XSLT to produce an Excel binary?  This is an approach
I find myself taking, but mostly because of a mixed user base who
might be still using versions of Excel earlier than 2000.

Jon Gorman

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.