RE: Converting XML File to Excel

Subject: RE: Converting XML File to Excel
From: "Robert C. Lyons" <boblyons@xxxxxxxxxx>
Date: Thu, 4 May 2000 00:22:04 -0400

John Connolly asked:

Is there an API available someplace that can transform a file in XML format into a MS Excel file?

You can use an XSLT stylesheet to convert an XML document into a CSV file,

which can be imported into Excel, 123, Quattro, etc.

Some caveats about CSV:

- CSV files do not preserve spreadsheet formulas, formatted text, etc.

- If a data value contains a comma, a quote character or a line

separator, then the value must be enclosed in quotes; also,

each quote in the data value must be preceded (i.e., escaped)

by a quote character. All this can be done in XSLT, but it's

not trivial.

I'm currently writing an XSLT stylesheet that transforms an XML document

into a SYLK file. SYLK is Microsoft's Symbolic Link format. SYLK files

can be imported into and exported from Excel. I believe that 123 and Quattro

also support SYLK. A spreadsheet in SYLK format can contain formulas,

formatted text (e.g., blue bold 18-pt. text), borders, etc.

I'm having trouble finding good documentation on SYLK.

I found links to some terse documents explaining SYLK at

http://www.faqs.org/faqs/spreadsheets/faq/.

Does anyone know where I can find a good document

explaining the SYLK format?

Thanks.

Bob

------
Bob Lyons
E-Commerce Consultant
Unidex, Inc.
1-732-975-9877
boblyons@xxxxxxxxxx
http://www.unidex.com/

Current Thread
Converting XML File to Excel johnc - Wed, 3 May 2000 10:10:06 -0600 Robert C. Lyons - Thu, 4 May 2000 00:22:04 -0400 <= Mike Brown - Thu, 4 May 2000 10:12:25 -0600 (MDT) <Possible follow-ups> DuCharme, Robert - Wed, 3 May 2000 13:52:52 -0400 DuCharme, Robert - Thu, 4 May 2000 14:23:54 -0400

<- Previous	Index	Next ->
Converting XML File to Excel, johnc	Thread	Re: Converting XML File to Excel, Mike Brown
Re: expression value not a node set, Mike Brown	Date	Re: Attributes, modes and templates, Alex Lancaster
	Month

Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced!

Accelerate XML development with our award-winning XML IDE - Download a free trial today!

Subscribe in XML format

RSS 2.0
Atom 0.3