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

Re: Converting Excel Table to XML document

  • From: Nicholas Sushkin <nsushkin@o...>
  • To: abcoatesecure-xmldev@y...,"XML-dev" <xml-dev@l...>
  • Date: Tue, 30 Dec 2008 09:54:48 -0500

Re:  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@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.


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


Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced!

Buy Stylus Studio Now

Download The World's Best XML IDE!

Accelerate XML development with our award-winning XML IDE - Download a free trial today!

Don't miss another message! Subscribe to this list today.
First Name
Last Name
Subscribe in XML format
RSS 2.0
Atom 0.3

Stylus Studio has published XML-DEV in RSS and ATOM formats, enabling users to easily subcribe to the list from their preferred news reader application.

Stylus Studio Sponsored Links are added links designed to provide related and additional information to the visitors of this website. they were not included by the author in the initial post. To view the content without the Sponsor Links please click here.

Site Map | Privacy Policy | Terms of Use | Trademarks
Free Stylus Studio XML Training:
W3C Member
Stylus Studio® and DataDirect XQuery ™are products from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2013 All Rights Reserved.