Subject: Re: XML _TO_ Spreadsheet?? From: Arie Golos <agolos@xxxxxxx> Date: Tue, 29 Aug 2000 13:23:55 -0400 |
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@xxxxxxxxxx' > 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
Current Thread |
---|
|
<- Previous | Index | Next -> |
---|---|---|
RE: XML _TO_ Spreadsheet??, Robert C. Lyons | Thread | RE: XML _TO_ Spreadsheet??, Chris Bayes |
RE: Uses of XSLT, Joshua Allen | Date | Re: Requirements for XSLT 1.1 (rtf/, Steve Muench |
Month |