RE: XML _TO_ Spreadsheet??

["Robert C. Lyons" <boblyons at unidex dot com>]

jr wrote:
> Are there any XSL-lets out there that do this kind of evil 
> duty?  Like 
> converting it to tab or comma-delimited and somehow 
> preserving attributes and a 
> shread of inheritance?  My XML is only a 2-deep hierarchy, so 
> there shouldn't be 
> much impedance mis-match.  I tried the archives but they kept 
> stalling in the 
> search.

jr,

A few months ago, I wrote some XSLT stylesheets that 
converted XML documents into spreadsheets for a client. 
Here's what I learned:

You can transform the XML into an HTML table, which can be
opened by Excel 97+. Excel will honor the HTML attributes
that control text size, color, etc.

If some of your users have spreadsheet software that can't
import/open an HTML table but that can open a SYLK file, 
then you can transform the XML into SYLK. SYLK (Symbolic
Link) is a text-based interchange format for spreadsheets;
it supports formulas, borders, fonts, point sizes, etc.
SYLK is supported by Excel and other spreadsheet packages. 
SYLK is the RTF of spreadsheets.

Hope this helps.

Bob

<sig name    = 'Bob Lyons'
     title   = 'E-Commerce Consultant'
     company = 'Unidex, Inc.'
     phone   = '+1-732-975-9877'
     email   = 'boblyons@unidex.com'
     url     = 'http://www.unidex.com/'
     plug    = 'Home of XML Convert'   />



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