Thanks for the response. I'm using the latest version ad from http://poi.apache.org/ poi-3.6. The files you say I have already linked to my project and I don't have any problem reading or modifying the workbook but when I go to save it fails. The poi-ooxml-schemas-3.6-20091214.jar is missing a class that it is required when saving as from the exception trace in my original post.
I've tried to look for ooxml-schemas-1.0.jar as I have also found in the internet for this problem and now you seem to advice but I could not find it in 3.5 as there isn't any poi-ooxml-schemas-3.5???.jar Also I have the concern that any other version may not be compatible with 3.6. So, I've just converted my XLSX file to XLS and I'll try with this version. -----Original Message----- From: MSB [mailto:[email protected]] Sent: 29 March 2010 15:11 To: [email protected] Subject: Re: Class Not found in version 3.6-20091214 If you are trying to work with the newer xml based file format - Excel 2007 on - then you will need to reference additional java archives on your classpath. Look for archives with names similar to these in the version of POI that you have; poi-3.6-beta1-20091007.jar poi-oxml-3.6-beta1-20091007.jar openxml4j-1.0-beta.jar xmlbeans-2.3.0.jar ooxml-schemas-1.0.jar dom4j-1.6.1.jar To reiterate, you will need to locate the files you have downloaded with names most closely matching the examples I have given and add those onto your classpath. Yours Mark B PS Some classes will not show compile time errors as they are only required at runtime. Amadeo Asco wrote: > > I have started using you library and would like to subscribe to the user > Mailing List. > > > > I have installed the libraries and run it, nice an easy to use. But it > fails > when trying to save into the file. The problem is a missing class: > > SEVERE: org/openxmlformats/schemas/spreadsheetml/x2006/main/CTDxfs$1 > > java.lang.NoClassDefFoundError: > org/openxmlformats/schemas/spreadsheetml/x2006/main/CTDxfs$1 > > at > org.openxmlformats.schemas.spreadsheetml.x2006.main.CTDxfs.<clinit>(Unknown > Source) > > at > org.openxmlformats.schemas.spreadsheetml.x2006.main.CTDxfs$Factory.newInstan > ce(Unknown Source) > > at > org.apache.poi.xssf.model.StylesTable.writeTo(StylesTable.java:362) > > at > org.apache.poi.xssf.model.StylesTable.commit(StylesTable.java:377) > > at > org.apache.poi.POIXMLDocumentPart.onSave(POIXMLDocumentPart.java:177) > > at > org.apache.poi.POIXMLDocumentPart.onSave(POIXMLDocumentPart.java:181) > > at org.apache.poi.POIXMLDocument.write(POIXMLDocument.java:214) > > at com.aas.phd.xsl.XSLMain.main(XSLMain.java:87) > > Caused by: java.lang.ClassNotFoundException: > org.openxmlformats.schemas.spreadsheetml.x2006.main.CTDxfs$1 > > at java.net.URLClassLoader$1.run(Unknown Source) > > at java.security.AccessController.doPrivileged(Native Method) > > at java.net.URLClassLoader.findClass(Unknown Source) > > at java.lang.ClassLoader.loadClass(Unknown Source) > > at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source) > > at java.lang.ClassLoader.loadClass(Unknown Source) > > ... 8 more > > > > > > I have looked into the different jar files and I could not find > "org/openxmlformats/schemas/spreadsheetml/x2006/main/CTDxfs$1". Please > could > anyone help? I will submit my question to the Mailing list as soon as I am > subscribed. > > > > > -- View this message in context: http://old.nabble.com/Class-Not-found-in-version-3.6-20091214-tp28069085p280 69877.html Sent from the POI - User mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
