使用POI操作Excel时new XSSFWorkbook ()报错java.lang.NoSuchMethodError解决方案
来源:互联网 发布:阿里云客服考试好考吗 编辑:程序博客网 时间:2024/06/04 18:29
使用最新的POI3.11时,在运行
Workbook workBook = new XSSFWorkbook ();这段代码时出现错误:
java.lang.NoSuchMethodError: javax.xml.stream.XMLEventFactory.newFactory()Ljavax/xml/stream/XMLEventFactory; at org.apache.poi.openxml4j.opc.internal.marshallers.PackagePropertiesMarshaller.<clinit>(PackagePropertiesMarshaller.java:45) at org.apache.poi.openxml4j.opc.OPCPackage.init(OPCPackage.java:161) at org.apache.poi.openxml4j.opc.OPCPackage.<init>(OPCPackage.java:141) at org.apache.poi.openxml4j.opc.Package.<init>(Package.java:37) at org.apache.poi.openxml4j.opc.ZipPackage.<init>(ZipPackage.java:65) at org.apache.poi.openxml4j.opc.OPCPackage.create(OPCPackage.java:337) at org.apache.poi.xssf.usermodel.XSSFWorkbook.newPackage(XSSFWorkbook.java:410) at org.apache.poi.xssf.usermodel.XSSFWorkbook.<init>(XSSFWorkbook.java:217) at org.apache.poi.xssf.streaming.SXSSFWorkbook.<init>(SXSSFWorkbook.java:216) at org.apache.poi.xssf.streaming.SXSSFWorkbook.<init>(SXSSFWorkbook.java:185) at org.apache.poi.xssf.streaming.SXSSFWorkbook.<init>(SXSSFWorkbook.java:160) at org.apache.poi.xssf.streaming.SXSSFWorkbook.<init>(SXSSFWorkbook.java:135) at org.apache.poi.xssf.streaming.SXSSFWorkbook.<init>(SXSSFWorkbook.java:96) at TestExport.test(TestExport.java:11) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:44) at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:15) at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:41) at org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:20) at org.junit.runners.BlockJUnit4ClassRunner.runNotIgnored(BlockJUnit4ClassRunner.java:79) at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:71) at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:49) at org.junit.runners.ParentRunner$3.run(ParentRunner.java:193) at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:52) at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:191) at org.junit.runners.ParentRunner.access$000(ParentRunner.java:42) at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:184) at org.junit.runners.ParentRunner.run(ParentRunner.java:236) at org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:50) at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:467) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:683) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:390) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:197)
将XSSFWorkbook改为HSSFWorkbook即可,即上述代码修改为;
Workbook workBook = new HSSFWorkbook ();
0 6
- 使用POI操作Excel时new XSSFWorkbook ()报错java.lang.NoSuchMethodError解决方案
- 使用POI时报java.lang.NoSuchMethodError错误
- JAVA POI 读取2013 EXCEL时 XSSFWorkbook(fis);出错
- JAVA POI 读取2007 EXCEL时 XSSFWorkbook(fis);出错
- JAVA POI 读取2013 EXCEL时 XSSFWorkbook(fis);出错
- 使用POI导入EXCEL报java.lang.IncompatibleClassChangeError
- new AndroidDriver报错java.lang.NoSuchMethodError: com.google.common.base.Throwables.throwIfUnchecked
- 升级到Weblogic10时,启动报错java.lang.NoSuchMethodError
- weblogic启动报错 java.lang.NoSuchMethodError
- POI操作Excel出错:java.lang.IncompatibleClassChangeError
- 解决 POI 操作2007格式的Excel报错问题:java.lang.ClassNotFoundException: org.apache.xmlbeans.XmlOptionsz
- java.lang.NoSuchMethodError错误解决方案
- java使用poi操作excel
- JAVA使用POI操作excel
- Java使用POI操作Excel
- JAVA使用POI操作excel
- java使用poi操作Excel
- java使用poi操作excel
- Cocos3.0 Editbox输入框的运用。
- 数组排序
- 我的[GO]语言程序变大了?
- android 中出现error opening trace file: No such file or directory (2)错误的解决办法
- ActivityManagerNative 反射
- 使用POI操作Excel时new XSSFWorkbook ()报错java.lang.NoSuchMethodError解决方案
- Android 基于google Zxing实现二维码、条形码扫描,仿微信二维码扫描效果
- MYSQL学习笔记(十)存储过程(续)
- Static Storage vs Heap vs Stack
- 2015台湾移动游戏市场白皮书
- Struts2之拦截器
- 经典CUDA教程
- workqueue
- slidingmenu_library