As far as I understand the root problem, only clients using MSO2007/2010 are concerned.
They can read and generate XML and binary both, but others having MSO2003 or older may be able to read binary only (if they do not have the MSO 2007 converter pack installed on top of their base installation). Thus it should be sufficient to be able to read XML and binary (as produced by MSO2007/2010), and output binary only, although this may look somewhat "old fashioned" for client users concerned. But it should work :-) Regards, --cg > -----Original Message----- > From: MSB [mailto:markbrd...@tiscali.co.uk] > Sent: Friday, June 11, 2010 5:58 PM > To: user@poi.apache.org > Subject: Re: How to convert .xls to .xlsx > > > You have a few options but quite a few limitations really. > > 1. POI does not have any method that you can call to convert from one file > format to another. You could however, use the api to open a workbook, > extract it's contents and use that information to create a new workbook in > the appropriate format, but there are going to be limiations with this, > not > the least of which will be charts. > > 2. OpenOffice, and therefore JODConverter, may well be out of the question > becaue I believe that it will not allow you to save a workbook in the > newer > XML based format. It will open both binary and xml based Excel workbooks > and > it will save a workbook in binary format but not, at least as far as I am > aware, the xml based one. > > 3. You could take a look at the tools Aspose market but all of these are > commercial products and I believe that they are far from cheap. > > 4. Excel itself. This is the obvious solution and it will definately > support > conversion between the file formats. Further, it is possible to 'automate' > the process by controlling an instance of the application from java code; > OLE/COM using a third party library such as JACOB. This could however > limit > the platforms you can run on and I have no idea how it would work in your > current architecture. > > 5. There are various websites that you can upload a file to and rely upon > their software to convert it from one format into another. You would need > to > test them out in order to find one that worked quickly and reliably and, > of > course, you would only be able to processw rokbooks that contained no > sensitive information. > > That's about all I can think of at the moment but I am sure there are > other > options and confident other list members will know of them. > > Yours > > Mark B > > Yours > > Mark B > > > Umesh Kilkile wrote: > > > > Hi, > > > > I'm Umesh. I'm working on a web based project which is written in > Servlets > > and JSP's. My project allows clients to upload / download > > MS Excel sheets. I'm using MS Excel 2003 (.xls file format ) . But > clients > > may be using MS Excel 2007/2010 (.xlsx file format) . So i need a > solution > > in Java or a tool in Java to automate the task of converting *.xls to > > .xlsx > > and vice-versa.* > > ** > > I hope you will suggest me a good solution to this problem. > > > > Thank You , > > > > Umesh > > > > > > -- > View this message in context: http://old.nabble.com/How-to-convert-.xls- > to-.xlsx-tp28852762p28857027.html > Sent from the POI - User mailing list archive at Nabble.com. > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: user-unsubscr...@poi.apache.org > For additional commands, e-mail: user-h...@poi.apache.org > > > !DSPAM:4c125d3117321375817940! > > --------------------------------------------------------------------- To unsubscribe, e-mail: user-unsubscr...@poi.apache.org For additional commands, e-mail: user-h...@poi.apache.org
