Re: Excel to XML

[Anatole Tartakovsky <anatolet@teamcti.com>]

I think you know the answer, just to make sure there are no extra steps:
1. Use Excel automation to save Excel file in (x)HTML format.
Example of Excel output(data portion):
<table x:str border=0 cellpadding=0 cellspacing=0 width=320
style='border-collapse:
 collapse;table-layout:fixed;width:240pt'>
 <col width=64 span=5 style='width:48pt'>
 <tr height=17 style='height:12.75pt'>
  <td class=xl15 width=64 style='width:48pt'></td>
  <td class=xl15 width=64 style='width:48pt'></td>
  <td class=xl15 width=64 style='width:48pt'></td>
  <td class=xl15 width=64 style='width:48pt'></td>
  <td class=xl15 width=64 style='width:48pt'></td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 colspan=2 class=xl15
style='height:12.75pt;mso-ignore:colspan'></td>
  <td class=xl15 x:num="5"></td>
  <td class=xl15 x:num="56"></td>
  <td class=xl15 x:num="61" x:fmla="=D2+C2"></td>
 </tr>
 <tr height=51 style='height:38.25pt;mso-xlrowspan:3'>
  <td height=51 colspan=5 class=xl15
style='height:38.25pt;mso-ignore:colspan'></td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl15 style='height:12.75pt'></td>
  <td class=xl15>sdfsdf</td>
  <td class=xl15>sdfsdf</td>
  <td colspan=2 class=xl15 style='mso-ignore:colspan'></td>
 </tr>
</table>
2. Use "universal" XSL  to transform "table" portion into data sections
3. If you need metadata with presentation to show Excel on Web, load
document into HTML DOM and extract  classes and presentation information to
either separate XML file or section of the output. ( Can be done once for a
particular class of the document). Create presentation XSL  from metadata
Regards,
Anatole
----- 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