poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From MSB <markbrd...@tiscali.co.uk>
Subject Re: How to convert XMLSS to MS EXCEL
Date Thu, 07 Jan 2010 07:43:54 GMT

Morning Max,

Sorry, I should have made it clear that the term OpenXML is used to refer to
the XML formatted files produced by Office 2007 and later so I think that we
are talking about the same thing here
(http://openxmldeveloper.org/default.aspx). Sadly, there is no easy way to
convert between the two versions unless you use Excel itself, OpenOffice or
purchase a component/tool/library that will support this (Aspose might for
instance but I do not know and understand it is expensive). You could use
XSSF/HSSF to perform the work for you but, as I indicated, there are areas
that XSSF does not yet support - data validations being the main one - and
there are likely to be wrinkles that need ironing out during the conversion
- charts and fonts are the two areas I am not at all sure about.


Mark B

There could be one wrinkle to all of this. Excel 2003 allowed users to save
files in an XML format, but this was very different to the newer zipped XML
files produced by later versions of Office and that conform to yje ECMA-376
standard. There is a very simple way to tell them apart, try to open the
file using a simple text editor; if you have an Excel 2003 XML file you will
see a file of XML markup.

Max Zhao wrote:
> Thanks so much for your reply Mark!
> I didn't mean OpenXML, I am trying to convert a MS XML Spreadsheet to MS
> EXCEL(native), both are Microsoft version. The project I am working on is
> a web based project, it can generate/import MS XML Spreadsheet, But now we
> will change the format from MS XML Spreadsheet to MS native Excel so I am
> looking for a simple way to handle this. Do you have any ideas? Thanks for
> your help!
> Max Zhao

View this message in context: http://old.nabble.com/How-to-convert-XMLSS-to-MX-EXCEL-tp26952438p27056173.html
Sent from the POI - User mailing list archive at Nabble.com.

To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org

View raw message