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

Re: Excel to XML

• From: Jeff Veit <jeff.veit@t...>
• To: =?Windows-1252?Q?Jos=E9_Manuel_Beas?= <jmbeas@t...>,xml-dev@l...
• Date: Mon, 15 Jan 2001 18:03:41 +0000

Infoteria have a system. (I am not affiliated with them.)

It's aimed at recurrently having to save the same spreadsheet. There's a
one-time set up of a mapping, and providing the spreadsheet doesn't change,
you don't have to remap. Have tested with small spreadsheets and it works.

There is unlikely to be a general automated solution because unless you want
to just transfer formatting info to XML in semi-structured format (e.g.
<row><cell>content</cell><cell...etc</row> ), software can't divine the
mapping from Excel to XML.

Jeff Veit


http://www.tanasity.com/ - Tanasity develops software and net applications
http://www.tangledtime.com/xmlist - The beginnings of an XML application
directory - please add stuff
http://www.tangledtime.com/ - New! Discussion about the net, software and
business - come and contribute

Tanasity
Tel: +44 (0)1223 721513
Email: jeff.veit@t...


----- Original Message -----
From: "José Manuel Beas" <jmbeas@t...>
To: "XML-DEV" <xml-dev@l...>
Sent: Monday, January 15, 2001 5:04 PM
Subject: RE: Excel to XML


Thanks to all answers. We're looking for an automated solution using
VBA+MSXML or something like that. While this kind of solution is found,
we'll save the single-sheet Excel-books into HTML and with a simple XSLT
translate the <table><tr><td></td></tr></table> structure into a customized
xml format.

Best regards,
--
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

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

• Prev by Date: RE: Excel to XML
• Next by Date: RE: Transforming an XML Document into another
• Previous by thread: RE: Excel to XML
• Next by thread: Re: Excel to XML
• Index(es):
  • Date
  • Thread