OASIS Mailing List ArchivesView the OASIS mailing list archive below
or browse/search using MarkMail.


Help: OASIS Mailing Lists Help | MarkMail Help

[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index]
Re: [xml-dev] Converting Excel Table to XML document


If your spreadsheet is from Excel 95, 97, 2000, XP, and 2003, try JExcelAPI. 
It's a pure Java library which can read Excel format natively. They have a 
demo program which outputs XML.

See http://www.andykhan.com/jexcelapi/tutorial.html#demo+programs

java -jar jxl.jar -xml -format spreadsheet.xls

Nicholas Sushkin, Senior Software Engineer
http://www.openfinance.com http://www.wealthinformationexchange.com

On Saturday 27 December 2008 18:10, Anthony B. Coates (XML-Dev) wrote: 

> 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.


[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index]

News | XML in Industry | Calendar | XML Registry
Marketplace | Resources | MyXML.org | Sponsors | Privacy Statement

Copyright 1993-2007 XML.org. This site is hosted by OASIS