[XML-DEV Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message] Re: Excel to XML
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@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
|
PURCHASE STYLUS STUDIO ONLINE TODAY!Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced! Download The World's Best XML IDE!Accelerate XML development with our award-winning XML IDE - Download a free trial today! Subscribe in XML format
|