This is the mail archive of the
xsl-list@mulberrytech.com
mailing list .
Re: XML _TO_ Spreadsheet??
- To: xsl-list at mulberrytech dot com
- Subject: Re: XML _TO_ Spreadsheet??
- From: Arie Golos <agolos at emc dot com>
- Date: Tue, 29 Aug 2000 13:23:55 -0400
- References: <000901c011ce$95eb39d0$62c80318@etntwn1.nj.home.com>
- Reply-To: xsl-list at mulberrytech 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