Re: [xml-dev] Converting Excel Table to XML document

["Anthony B. Coates (XML-Dev)" <abcoatesecure-xmldev@yahoo.co.uk>]

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@dpawson.co.uk>  
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/