Re: XML _TO_ Spreadsheet??

[Arie Golos <agolos at emc dot com>]

In addition Bob's info: I downloaded from the microsoft site:
"Microsoft® Office HTML and XML Reference".  This one contains xml
attributes that Excel knows about.  For example, one that I used was to
enforce
the data to being a string instead of a number.
Arie

"Robert C. Lyons" wrote:

> 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


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