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

Re: Converting Excel Table to XML document

• From: "Anthony B. Coates (XML-Dev)" <abcoatesecure-xmldev@y...>
• To: XML-dev <xml-dev@l...>
• Date: Sat, 27 Dec 2008 23:10:20 -0000

Interesting.  That definitely *didn't* work for me, because I found that  
the OpenOffice XML format doesn't always have the same number of columns  
in each row, which makes it hard to process.  I'm sure there is some good  
reason for that, do save space, but I couldn't work out what the rules  
were, and how to predict when a column would be missing in a row.

When that happens, the dumbed-down HTML approach (or the CSV approach) can  
be easier.

Cheers, Tony.

On Sat, 27 Dec 2008 15:42:55 -0000, Dave Pawson <davep@d...>  
wrote:

> Anthony B. Coates (XML-Dev) wrote:
>> What I've found easiest is to export an Excel sheet as HTML, run that  
>> through a "tidy" program to convert it into XHTML, then process the  
>> XHTML with XSLT (or your XML processing tool of choice).
>
>
> I got better results using excel -> Open Office, then
> process the xml using XSLT.

-- 
Anthony B. Coates
Director and CTO
Londata Ltd
UK: +44 (20) 8816 7700, US: +1 (239) 344 7700
Mobile/Cell: +44 (79) 0543 9026
Data standards participant: genericode, ISO 20022 (ISO 15022 XML),  
UN/CEFACT, MDDL, FpML, UBL.
http://www.londata.com/

• References:
  • Re: XML Schema: "Best used with the ______ tool"
    • From: Boris Kolpackov <boris@c...>
  • Re: XML Schema: "Best used with the ______ tool"
    • From: "Andrew Welch" <andrew.j.welch@g...>
  • Re: XML Schema: "Best used with the ______ tool"
    • From: "Andrew Welch" <andrew.j.welch@g...>
  • Converting Excel Table to XML document
    • From: "Oscar Rodriguez" <orodriguez@i...>
  • RE: Converting Excel Table to XML document
    • From: "Liz Andrews" <liz.andrews@a...>
  • Re: Converting Excel Table to XML document
    • From: Stefan Vasile <stefan@o...>
  • Re: Converting Excel Table to XML document
    • From: "Ramkumar Menon" <ramkumar.menon@g...>
  • Re: Converting Excel Table to XML document
    • From: "Anthony B. Coates (XML-Dev)" <abcoatesecure-xmldev@y...>
  • Re: Converting Excel Table to XML document
    • From: Dave Pawson <davep@d...>