Is there an API available
someplace that can transform a file in XML format into a MS Excel file?
can use an XSLT stylesheet to convert an XML document into a CSV
can be imported into Excel, 123, Quattro, etc.
caveats about CSV:
files do not preserve spreadsheet formulas, formatted text,
- If a
data value contains a comma, a quote character or a line
separator, then the value must be enclosed in quotes;
quote in the data value must be preceded (i.e., escaped)
quote character. All this can be done in XSLT, but it's
currently writing an XSLT stylesheet that transforms an XML
SYLK file. SYLK is Microsoft's Symbolic Link format. SYLK
imported into and exported from Excel. I believe that 123 and
support SYLK. A spreadsheet in SYLK format can contain formulas,
formatted text (e.g., blue bold 18-pt. text), borders,
having trouble finding good documentation on SYLK.
found links to some terse documents explaining SYLK at
anyone know where I can find a good document
explaining the SYLK format?