OASIS Mailing List ArchivesView the OASIS mailing list archive below
or browse/search using MarkMail.


Help: OASIS Mailing Lists Help | MarkMail Help

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Excel to XML

Two approaches -

1) Use VBA  programming in excel (i.e., write a macro)  that walks through the
data and outputs xml.

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.

Tom P

----- Original Message -----
From: "José Manuel Beas" <jmbeas@telenium.es>
To: "XML-DEV" <xml-dev@lists.xml.org>
Sent: Monday, January 15, 2001 7:27 AM
Subject: Excel to XML

> Hello everyone,
> Does anyone know how to transform a Microsoft Excel file into an XML format?
> Thanks,
> --
> José Manuel Beas (jmbeas@telenium.es)
> Software Engineer
> TELENIUM, The New Millennium Telecom Company
> Agustín de Foxá, 25, plta. 13
> 28036 MADRID
> Tel. +34 91 315 85 62 (ext. 260)
> Fax +34 91 315 63 37
> http://www.telenium.es