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

Re: Excel to XML

• From: "Thomas B. Passin" <tpassin@h...>
• To: XML-DEV <xml-dev@l...>
• Date: Mon, 15 Jan 2001 16:43:28 -0500

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@t...>
To: "XML-DEV" <xml-dev@l...>
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@t...)
> 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
>
>

• Follow-Ups:
  • RE: Excel to XML
    • From: Danny Ayers <danny@p...>

• References:
  • Excel to XML
    • From: =?UNKNOWN?Q?Jos=E9?= Manuel Beas <jmbeas@t...>

• Prev by Date: Dynamic call template
• Next by Date: Re: XPointer and Sun patent
• Previous by thread: Re: Excel to XML
• Next by thread: RE: Excel to XML
• Index(es):
  • Date
  • Thread