I have installed LibreOffice_5.0.4_Win_x86 and converting xls to xlsx files through java.
The Filters I tried are :
- Microsoft Excel 2007-2013 XML [What are the 5.x Calc Import/Export Filters?]
2)MS Excel 2007 XML [Is there a *.xlsx Filter Option?]
None of the above filters works for XLSX but able to generate xls files.
I use the below java code to save xlsx files;
XStorable xstorable = (XStorable) UnoRuntime.queryInterface(XStorable.class, doc);
PropertyValue[] propertyvalue = new PropertyValue[2];
propertyvalue[0] = new PropertyValue();
propertyvalue[0].Name = "Overwrite";
propertyvalue[0].Value = new Boolean(true);
propertyvalue[1] = new PropertyValue();
propertyvalue[1].Name = "FilterName";
propertyvalue[1].Value =MS Excel 2007 XML;
xstorable.storeAsURL(targetDocName, propertyvalue);
The error I got is below
2016-02-17 21:27:48,886 ERROR [ajp-bio-8009-exec-1] ExcelProcess [ExcelProcess.java:131] Error occured while saving spreadsheet to a new url name
com.sun.star.task.ErrorCodeIOException: SfxBaseModel::impl_store <file:///D:/app/Apps/abc/modules/temp/0.6911649132589721.xlsx> failed: 0x81a
at com.sun.star.lib.uno.environments.remote.Job.remoteUnoRequestRaisedException(Job.java:160) ~[jurt-5.0.4.jar:na]
at com.sun.star.lib.uno.environments.remote.Job.execute(Job.java:124) ~[jurt-5.0.4.jar:na]
at com.sun.star.lib.uno.environments.remote.JobQueue.enter(JobQueue.java:319) ~[jurt-5.0.4.jar:na]
at com.sun.star.lib.uno.environments.remote.JobQueue.enter(JobQueue.java:288) ~[jurt-5.0.4.jar:na]
at com.sun.star.lib.uno.environments.remote.JavaThreadPool.enter(JavaThreadPool.java:80) ~[jurt-5.0.4.jar:na]
at com.sun.star.lib.uno.bridges.java_remote.java_remote_bridge.sendRequest(java_remote_bridge.java:617) ~[jurt-5.0.4.jar:na]
at com.sun.star.lib.uno.bridges.java_remote.ProxyFactory$Handler.request(ProxyFactory.java:144) ~[jurt-5.0.4.jar:na]
at com.sun.star.lib.uno.bridges.java_remote.ProxyFactory$Handler.invoke(ProxyFactory.java:128) ~[jurt-5.0.4.jar:na]
at com.sun.proxy.$Proxy81.storeAsURL(Unknown Source) ~[na:na]
Please help us to resolve this issue and let me know if you need more information.