[XML-DEV Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message]

RE: Excel to XML

• From: Danny Ayers <danny@p...>
• To: "Thomas B. Passin" <tpassin@h...>, XML-DEV <xml-dev@l...>
• Date: Tue, 16 Jan 2001 22:08:03 +0600

> 2) save the spreadsheet as a comma- or tab-delimited file, then
> write a simple
> script to convert it.  This is not hard.  Suitable languages are
> Python, Perl,
> and Awk.
>
> The above assumes that you want to convert one particular
> spreadsheet layout.
> A general approach would take more work, but probably not much.

Another suitable language is Java. I've put a simple, lightweight (doesn't
use SAX/DOM), moderately customisable tool "CSVToXML" at www.isacat.net

If the server's playing up (again) it's also at sourceforge in the Java
'snippets' section (I think that's what they call it).

Another alternative is to use Excel's "save as web page" (97 onwards?), use
an industrial cleaner to tidy it up, and then a HTML -> XHTML tool.

Cheers,
Danny.

• References:
  • Re: Excel to XML
    • From: "Thomas B. Passin" <tpassin@h...>

• Prev by Date: RE: DTD to W3C schema file?
• Next by Date: Re: How could RDDL be distributed ?
• Previous by thread: Re: Excel to XML
• Next by thread: RE: Excel to XML
• Index(es):
  • Date
  • Thread