2013年9月4日星期三

java opi operation EXCEL java.lang.ClassNotFoundException:

I have cited the poi-3.6.jar package
. classpath can explain
,

performing a simple operation error occurred , do not know why ......


code is as follows :



import java.io.File;
import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.FileOutputStream;
import java.io.IOException;
import java.util.Date;
import java.util.HashMap;
import java.util.Map;
import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.poifs.filesystem.POIFSFileSystem;



FileOutputStream fos = new FileOutputStream("d:\\foo.xls");
HSSFWorkbook wb = new HSSFWorkbook();
HSSFSheet s = wb.createSheet();
wb.setSheetName(0, "Matrix");
for(short i=0; i<50; i++) {
  HSSFRow row = s.createRow(i);
  for(short j=0; j<50; j++) {
   HSSFCell cell = row.createCell(j);
   cell.setCellValue(""+i+","+j);
  }
}
wb.write(fos);
fos.close();





Caused by:
java.lang.ClassNotFoundException: org.apache.poi.poifs.filesystem.POIFSFileSystem
at java.net.URLClassLoader $ 1.run (URLClassLoader.java: 200)
at java.security.AccessController.doPrivileged (Native Method)
at java.net.URLClassLoader.findClass (URLClassLoader.java: 188)
at java.lang.ClassLoader.loadClass (ClassLoader.java: 307)
at org.codehaus.classworlds.RealmClassLoader.loadClassDirect (RealmClassLoader.java: 195)
at org.codehaus. classworlds.DefaultClassRealm.loadClass (DefaultClassRealm.java: 255)
at org.codehaus.classworlds.DefaultClassRealm.loadClass (DefaultClassRealm.java: 274)
at org.codehaus.classworlds.RealmClassLoader.loadClass ( RealmClassLoader.java: 214)
at java.lang.ClassLoader.loadClass (ClassLoader.java: 252)
at org.mortbay.jetty.webapp.WebAppClassLoader.loadClass (WebAppClassLoader.java: 375)
at org.mortbay.jetty.webapp.WebAppClassLoader.loadClass (WebAppClassLoader.java: 337)
at java.lang.ClassLoader.loadClassInternal (ClassLoader.java: 320)
at java.lang.Class.getDeclaredFields0 (Native Method)
at java.lang.Class.privateGetDeclaredFields (Class.java: 2291)
at java.lang.Class.getDeclaredFields (Class.java: 1743)
at org.springframework.util.ReflectionUtils.doWithFields (ReflectionUtils.java: 516)
at org.springframework.util.ReflectionUtils.doWithFields (ReflectionUtils.java: 500)
at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor.findResourceMetadata (CommonAnnotationBeanPostProcessor.java: 319)
at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor.postProcessMergedBeanDefinition (CommonAnnotationBeanPostProcessor.java: 277)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyMergedBeanDefinitionPostProcessors (AbstractAutowireCapableBeanFactory.java: 745)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean (AbstractAutowireCapableBeanFactory.java: 448)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory $ 1.run (AbstractAutowireCapableBeanFactory.java: 409)
at java.security.AccessController.doPrivileged (Native Method)
at org.springframework . beans.factory.support.AbstractAutowireCapableBeanFactory.createBean (AbstractAutowireCapableBeanFactory.java: 380)
at org.springframework.beans.factory.support.AbstractBeanFactory $ 1.getObject (AbstractBeanFactory.java: 264)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton (DefaultSingletonBeanRegistry.java: 222)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean (AbstractBeanFactory.java: 261)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean (AbstractBeanFactory.java: 185)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean (AbstractBeanFactory.java: 164)
at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons (DefaultListableBeanFactory.java: 429)
at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization (AbstractApplicationContext.java: 728)
at org.springframework.context.support.AbstractApplicationContext.refresh (AbstractApplicationContext.java: 380)
at org.springframework.web.servlet.FrameworkServlet.createWebApplicationContext (FrameworkServlet.java: 402)
at org.springframework.web.servlet.FrameworkServlet.initWebApplicationContext (FrameworkServlet.java: 316)
at org.springframework.web.servlet.FrameworkServlet.initServletBean (FrameworkServlet.java: 282)
at org.springframework.web.servlet.HttpServletBean.init (HttpServletBean.java: 126)
at javax.servlet.GenericServlet.init (GenericServlet.java: 241)
at org.mortbay.jetty. servlet.ServletHolder.initServlet (ServletHolder.java: 433)
at org.mortbay.jetty.servlet.ServletHolder.getServlet (ServletHolder.java: 342)
at org.mortbay.jetty.servlet. ServletHolder.handle (ServletHolder.java: 463)
at org.mortbay.jetty.servlet.ServletHandler $ CachedChain.doFilter (ServletHandler.java: 1093)
at org.springframework.web.filter. CharacterEncodingFilter.doFilterInternal (CharacterEncodingFilter.java: 96)
at org.springframework.web.filter.OncePerRequestFilter.doFilter (OncePerRequestFilter.java: 76)
at org.mortbay.jetty.servlet.ServletHandler $ CachedChain.doFilter (ServletHandler.java: 1084)
at org.mortbay.jetty.servlet.ServletHandler.handle (ServletHandler.java: 360)
at org.mortbay.jetty.security.SecurityHandler. handle (SecurityHandler.java: 216)
at org.mortbay.jetty.servlet.SessionHandler.handle (SessionHandler.java: 181)
at org.mortbay.jetty.handler.ContextHandler.handle ( ContextHandler.java: 726)
at org.mortbay.jetty.webapp.WebAppContext.handle (WebAppContext.java: 405)
at org.mortbay.jetty.handler.ContextHandlerCollection.handle (ContextHandlerCollection. java: 206)
at org.mortbay.jetty.handler.HandlerCollection.handle (HandlerCollection.java: 114)
at org.mortbay.jetty.handler.HandlerWrapper.handle (HandlerWrapper.java: 152)
at org.mortbay.jetty.Server.handle (Server.java: 324)
at org.mortbay.jetty.HttpConnection.handleRequest (HttpConnection.java: 505)
at org.mortbay.jetty.HttpConnection $ RequestHandler.headerComplete (HttpConnection.java: 828)
at org.mortbay.jetty.HttpParser.parseNext (HttpParser.java: 514)
at org. mortbay.jetty.HttpParser.parseAvailable (HttpParser.java: 211)
at org.mortbay.jetty.HttpConnection.handle (HttpConnection.java: 380)
at org.mortbay.io.nio. SelectChannelEndPoint.run (SelectChannelEndPoint.java: 395)
at org.mortbay.thread.BoundedThreadPool $ PoolThread.run (BoundedThreadPool.java: 450)

------ Solution - ------------------------------------------
If the package is indeed imported if
Consider jar package conflicts
------ Solution ----------------------------- ---------------
you seen through the deployment of the file after the
see there is no version with a jar , but not the same
This may cause a phenomenon found
------ For reference only -------------------------- -------------

view in classPath do ?
------ For reference only -------------------------------------- -



packets directly into the project 's lib under it ah
------ For reference only -------------------- -------------------
version is not the same
------ For reference only ------------- --------------------------
errors are not found package ,
------ For reference only --- ------------------------------------
is classPath conflict , deleted, re from svn Get no problem
------ For reference only --------------------------------- ------



packets directly into the project 's lib under it ah

helped me a great big favor , thank you ! ! !

没有评论:

发表评论