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
