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

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

Tel: +44 (0)1223 721513
Email: jeff.veit@tanasity.com

----- Original Message -----
From: "José Manuel Beas" <jmbeas@telenium.es>
To: "XML-DEV" <xml-dev@lists.xml.org>
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@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