poi批量下载功能

最新推荐文章于 2024-09-25 19:03:43 发布
最新推荐文章于 2024-09-25 19:03:43 发布
阅读量1.9k 收藏 1
点赞数
分类专栏： Java基础 Struts2.3.24 Spring4.2.5 Apache Poi 文章标签： poi struts2.0 对象 内存
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/laborwork/article/details/52639162
版权

近期在写一个批量下载的功能时，由于需要下载的数据量以及sheet页较多，因此考虑使用poi中的一个SXSSFWorkbook类用以减小内存的消耗：
workbook = new SXSSFWorkbook(new XSSFWorkbook(), rowAccessWindowSize);
但是在使用过程中发现一直在new 这个对象时报错
错误提示如下：

struts2.dispatcher.Dispatcher -Exception occurred during processing request: null
java.lang.reflect.InvocationTargetException
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:497)
    at com.opensymphony.xwork2.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:450)
    at com.opensymphony.xwork2.DefaultActionInvocation.invokeActionOnly(DefaultActionInvocation.java:289)
    at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:252)
    at org.apache.struts2.rest.RestActionInvocation.invoke(RestActionInvocation.java:138)
    at org.apache.struts2.rest.RestWorkflowInterceptor.doIntercept(RestWorkflowInterceptor.java:228)
    at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)
    at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
    at org.apache.struts2.rest.RestActionInvocation.invoke(RestActionInvocation.java:138)
    at com.opensymphony.xwork2.validator.ValidationInterceptor.doIntercept(ValidationInterceptor.java:265)
    at org.apache.struts2.interceptor.validation.AnnotationValidationInterceptor.doIntercept(AnnotationValidationInterceptor.java:68)
    at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)
    at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
    at org.apache.struts2.rest.RestActionInvocation.invoke(RestActionInvocation.java:138)
    at com.opensymphony.xwork2.interceptor.ConversionErrorInterceptor.intercept(ConversionErrorInterceptor.java:138)
    at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
    at org.apache.struts2.rest.RestActionInvocation.invoke(RestActionInvocation.java:138)
    at org.apache.struts2.rest.ContentTypeInterceptor.intercept(ContentTypeInterceptor.java:66)
    at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
    at org.apache.struts2.rest.RestActionInvocation.invoke(RestActionInvocation.java:138)
    at com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:239)
    at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)
    at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
    at org.apache.struts2.rest.RestActionInvocation.invoke(RestActionInvocation.java:138)
    at com.opensymphony.xwork2.interceptor.StaticParametersInterceptor.intercept(StaticParametersInterceptor.java:191)
    at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
    at org.apache.struts2.rest.RestActionInvocation.invoke(RestActionInvocation.java:138)
    at org.apache.struts2.interceptor.CheckboxInterceptor.intercept(CheckboxInterceptor.java:91)
    at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
    at org.apache.struts2.rest.RestActionInvocation.invoke(RestActionInvocation.java:138)
    at org.apache.struts2.interceptor.FileUploadInterceptor.intercept(FileUploadInterceptor.java:252)
    at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
    at org.apache.struts2.rest.RestActionInvocation.invoke(RestActionInvocation.java:138)
    at com.opensymphony.xwork2.interceptor.ModelDrivenInterceptor.intercept(ModelDrivenInterceptor.java:100)
    at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
    at org.apache.struts2.rest.RestActionInvocation.invoke(RestActionInvocation.java:138)
    at com.opensymphony.xwork2.interceptor.ScopedModelDrivenInterceptor.intercept(ScopedModelDrivenInterceptor.java:141)
    at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
    at org.apache.struts2.rest.RestActionInvocation.invoke(RestActionInvocation.java:138)
    at com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:239)
    at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)
    at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
    at org.apache.struts2.rest.RestActionInvocation.invoke(RestActionInvocation.java:138)
    at org.apache.struts2.interceptor.ProfilingActivationInterceptor.intercept(ProfilingActivationInterceptor.java:104)
    at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
    at org.apache.struts2.rest.RestActionInvocation.invoke(RestActionInvocation.java:138)
    at org.apache.struts2.interceptor.debugging.DebuggingInterceptor.intercept(DebuggingInterceptor.java:256)
    at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
    at org.apache.struts2.rest.RestActionInvocation.invoke(RestActionInvocation.java:138)
    at com.opensymphony.xwork2.interceptor.ChainingInterceptor.intercept(ChainingInterceptor.java:145)
    at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
    at org.apache.struts2.rest.RestActionInvocation.invoke(RestActionInvocation.java:138)
    at com.opensymphony.xwork2.interceptor.I18nInterceptor.intercept(I18nInterceptor.java:161)
    at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
    at org.apache.struts2.rest.RestActionInvocation.invoke(RestActionInvocation.java:138)
    at com.opensymphony.xwork2.interceptor.PrepareInterceptor.doIntercept(PrepareInterceptor.java:171)
    at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)
    at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
    at org.apache.struts2.rest.RestActionInvocation.invoke(RestActionInvocation.java:138)
    at org.apache.struts2.interceptor.MessageStoreInterceptor.intercept(MessageStoreInterceptor.java:194)
    at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
    at org.apache.struts2.rest.RestActionInvocation.invoke(RestActionInvocation.java:138)
    at org.apache.struts2.interceptor.ServletConfigInterceptor.intercept(ServletConfigInterceptor.java:164)
    at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
    at org.apache.struts2.rest.RestActionInvocation.invoke(RestActionInvocation.java:138)
    at com.opensymphony.xwork2.interceptor.AliasInterceptor.intercept(AliasInterceptor.java:193)
    at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
    at org.apache.struts2.rest.RestActionInvocation.invoke(RestActionInvocation.java:138)
    at com.opensymphony.xwork2.interceptor.ExceptionMappingInterceptor.intercept(ExceptionMappingInterceptor.java:189)
    at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
    at org.apache.struts2.rest.RestActionInvocation.invoke(RestActionInvocation.java:138)
    at com.opensymphony.xwork2.DefaultActionProxy.execute(DefaultActionProxy.java:147)
    at org.apache.struts2.dispatcher.Dispatcher.serviceAction(Dispatcher.java:563)
    at org.apache.struts2.dispatcher.ng.ExecuteOperations.executeAction(ExecuteOperations.java:77)
    at org.apache.struts2.dispatcher.ng.filter.StrutsPrepareAndExecuteFilter.doFilter(StrutsPrepareAndExecuteFilter.java:99)
    at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
    at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)
    at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
    at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
    at com.asiainfo.portal.framework.external.PortalFirstFilter.doFilter(PortalFirstFilter.java:92)
    at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
    at com.sitech.dss.portal.security.filter.AppSecurityContextFilter.doFilter(AppSecurityContextFilter.java:101)
    at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:237)
    at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167)
    at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
    at com.sitech.dss.portal.security.filter.AppLogFilter.doFilter(AppLogFilter.java:56)
    at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:237)
    at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167)
    at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
    at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3730)
    at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3696)
    at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
    at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)
    at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2273)
    at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2179)
    at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1490)
    at weblogic.work.ExecuteThread.execute(ExecuteThread.java:256)
    at weblogic.work.ExecuteThread.run(ExecuteThread.java:221)
Caused by: java.lang.NoClassDefFoundError: Could not initialize class org.apache.poi.POIXMLTypeLoader
    at org.openxmlformats.schemas.spreadsheetml.x2006.main.CTWorkbook$Factory.newInstance(Unknown Source)
    at org.apache.poi.xssf.usermodel.XSSFWorkbook.onWorkbookCreate(XSSFWorkbook.java:425)
    at org.apache.poi.xssf.usermodel.XSSFWorkbook.<init>(XSSFWorkbook.java:227)
    at org.apache.poi.xssf.usermodel.XSSFWorkbook.<init>(XSSFWorkbook.java:218)
    at com.sitech.dss.esop2.report.action.ExcelUtils.<init>(ExcelUtils.java:49)
    at com.sitech.dss.esop2.report.action.BatchDownloadAction.batchDownload(BatchDownloadAction.java:45)
    ... 101 more
java.lang.NullPointerException
    at weblogic.servlet.internal.ServletResponseImpl.sendContentError(ServletResponseImpl.java:622)
    at weblogic.servlet.internal.ServletResponseImpl.sendError(ServletResponseImpl.java:666)
    at org.apache.struts2.dispatcher.Dispatcher.sendError(Dispatcher.java:906)
    at org.apache.struts2.dispatcher.Dispatcher.serviceAction(Dispatcher.java:586)
    at org.apache.struts2.dispatcher.ng.ExecuteOperations.executeAction(ExecuteOperations.java:77)
    at org.apache.struts2.dispatcher.ng.filter.StrutsPrepareAndExecuteFilter.doFilter(StrutsPrepareAndExecuteFilter.java:99)
    at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
    at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)
    at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
    at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
    at com.asiainfo.portal.framework.external.PortalFirstFilter.doFilter(PortalFirstFilter.java:92)
    at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
    at com.sitech.dss.portal.security.filter.AppSecurityContextFilter.doFilter(AppSecurityContextFilter.java:101)
    at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:237)
    at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167)
    at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
    at com.sitech.dss.portal.security.filter.AppLogFilter.doFilter(AppLogFilter.java:56)
    at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:237)
    at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167)
    at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
    at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3730)
    at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3696)
    at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
    at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)
    at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2273)
    at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2179)
    at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1490)
    at weblogic.work.ExecuteThread.execute(ExecuteThread.java:256)
    at weblogic.work.ExecuteThread.run(ExecuteThread.java:221)

仔细阅读错误可以发现根本报错点是：

Caused by: java.lang.NoClassDefFoundError: Could not initialize class org.apache.poi.POIXMLTypeLoader
    at org.openxmlformats.schemas.spreadsheetml.x2006.main.CTWorkbook$Factory.newInstance(Unknown Source)
    at org.apache.poi.xssf.usermodel.XSSFWorkbook.onWorkbookCreate(XSSFWorkbook.java:425)
    at org.apache.poi.xssf.usermodel.XSSFWorkbook.<init>(XSSFWorkbook.java:227)
    at org.apache.poi.xssf.usermodel.XSSFWorkbook.<init>(XSSFWorkbook.java:218)
    at com.sitech.dss.esop2.report.action.ExcelUtils.<init>(ExcelUtils.java:49)
    at com.sitech.dss.esop2.report.action.BatchDownloadAction.batchDownload(BatchDownloadAction.java:45)

从网上查找了很多的方法大部分是说xmlbeans.jar包未引入或是版本太低，
apache官方poi问题集《http://poi.apache.org/faq.html#faq-N101E6》中是这么说的
I’m using the poi-ooxml-schemas jar, but my code is failing with “java.lang.NoClassDefFoundError: org/openxmlformats/schemas/something”
To use the new OOXML file formats, POI requires a jar containing the file format XSDs, as compiled by XMLBeans. These XSDs, once compiled into Java classes, live in the org.openxmlformats.schemas namespace.
这里的错误指示与我们的不尽相同，大概意思是说ooxml-schemas-1.3.jar包比poi-ooxml-schemas.jar poi-ooxml.jar包功能更全面，于是乎就下载了ooxml-schemas-1.3.jar地址：http://repo1.maven.org/maven2/org/apache/poi/ooxml-schemas/1.3/，放在项目中之后发现问题并解决，还是相同的问题，但是在阅读上面这个解决方法的同时，
这里写图片描述
这里 the components overview section 这个指向：http://poi.apache.org/overview.html这个页面，在这里我们可以清晰的看到POI中各个包之间的依赖关系以及各版本之间的说明
对比自己项目中的jar包发现有不少jar版本较低且与官方推荐的jar包版本不一致，因此决定下载最新的POI3.15jar包之后，去替换项目中的版本，具体jar包列表如下：
commons-codec-1.10.jar
junit-4.12.jar
commons-collections4-4.1.jar
log4j-1.2.17.jar
commons-logging-1.2.jar
poi-3.15.jar
poi-examples-3.15.jar
poi-excelant-3.15.jar
poi-ooxml-3.15.jar
poi-ooxml-schemas-3.15.jar
poi-scratchpad-3.15.jar
curvesapi-1.04.jar
xmlbeans-2.6.0.jar
引入这些jar包后，将项目中重复的jar删除，更新启动ok,运行成功。

特别注意：升级jar包版本时请谨慎，以防出现其他bug！

POI批量导入导出
09-11
可以实现POI的批量导入与导出。
Java操作POI批量导出多个excle，打压缩包
热门推荐
在路上。。。
08-01 1万+
一、前端JS //站内搜索查询报表-Excel导出 function exportRecord(){ var browseUrl=$("#browseUrl").val(); if(browseUrl == null || browseUrl == ""){ $.messager.show({ title : '友好提示', msg : '浏览资源ID,不能为
POI从3.14升级为5.2.0
最新发布
紫月7575的博客
09-25 570
从5.0.X开始，poi-ooxml–schemas被重命名为poi-ooxml–full。最新版是5.3.0，但是word转pdf的工具最新到poi的5.2.0，所以用这个版本了。最近word用的功能有点多，3.14功能太少，升级一下。
POI 批量导出文档
Luker_的博客
02-15 398
html页面代码 &lt;div class="columns pull-left"&gt; &lt;button class="btn btn-success" style="margin-left: 10px" shiro:hasPermission="app:activeInfo:download" onclick="downLoad();"&gt;
查询数据库数据生成多个poi excel，压缩成一个文件下载
qq_39573106的博客
10-09 258
package com.casic.smbss.ncp.application.common.util; import io.swagger.annotations.ApiOperation; import org.apache.poi.hssf.usermodel.HSSFCell; import org.apache.poi.hssf.usermodel.HSSFRow; import org.apache.poi.hssf.usermodel.HSSFSheet; import org.apach.
POI批量导入导出Demo,附带批量压缩
12-17
基于Java泛型POI制作的批量导入导出Excel文档工具类，附带批量压缩功能。
poi批量上传EXCEL文件
03-05
在IT行业中，尤其是在数据...总之，Apache POI是Java处理Excel的强大工具，它允许我们高效地读取和写入Excel文件，从而实现诸如批量上传数据等复杂功能。通过熟练掌握POI，我们可以大大提高数据处理的效率和灵活性。
java使用POI批量导入excel数据的方法
08-29
要使用 POI，需要下载相应的 jar 包，包括 poi-xx.jar、poi-ooxml-xx.jar、poi-xx.jar 等。 三、简单的一个读取 Excel 的 demo 下面是一个简单的读取 Excel 的 demo： ```java public static void ...
poi批量导入导出示例
02-20
在本文中，我们将深入探讨如何利用POI进行批量数据的导入与导出，尤其是针对Excel表格的处理。这将涉及到文件读写、工作簿和工作表的概念、单元格类型转换以及处理大数据量时的性能优化策略。 1. **POI的基本使用**...
poi实现excel模板下载和批量导入
weixin_42201579的博客
05-28 837
Excel的批量导入相信是很多软件绕不过去的功能吧。使用poi实现Execl模板下载和批量导入的功能特此记录一下。 先上结果界面的代码如下。 <fieldset class="layui-elem-field"> <div class="layui-field-box"> <form action="uploadSubjectExcel.action" method="post" enctype="multipart/form-data"> <di
poi可批量生成word
10-23
利用模板批量生成word文件，大大方便用户后台处理，节省时间
最新最全POI合集
02-03
包括最新版的Appache poi-3.11和利用POI的Excel导出导出工具类
java poi操作excel批量导入导出项目需要的jar包
01-18
java 开发中Poi操作excel批量导入导出项目需要的jar包
poi-ooxml-schemas-3.16.jar
06-14
poi-ooxml-schemas-3.16.jar
使用poi实现Excel下载
CatTSF的博客
12-04 2049
参考了一下文章： https://www.cnblogs.com/lcngu/p/7056875.html 前端： HTML +angularJS : HTML： a href="#" ng-click="export()">Exporta>JS： $scope.export = function () { $http({ method: "PO
java poi zip_Java 批量下载excel，并对excel赋值，压缩为zip文件（POI版）
weixin_29215391的博客
02-27 484
package com.neusoft.nda.servlet;import java.io.File;import java.io.FileInputStream;import java.io.FileNotFoundException;import java.io.FileOutputStream;import java.io.IOException;import java.io.Output...
POI HSSF实现ajax多个Excel同时导出
mike14777的博客
03-17 221
POI HSSF实现ajax多个Excel同时导出
Springboot apache poi 浏览器下载 excel
qiaobing1226的博客
06-14 660
springboot POST 接口，支持浏览器下载excel文件，具体实现实现： 2.controller 层添加接口 3.service层加入逻辑代码 4.实体类 5.工具类ExcelUtil 6.调用接口：
poi操作 excel 中文API文档
Mr_going的博客
07-30 2114
poi操作 excel 中文API文档 依赖： <dependency> <groupId>org.apache.poi</groupId> <artifactId>poi-ooxml</artifactId> <version>4.1.2</version> </dependency> <depende
poi批量导入实现？
07-28
通过以上步骤，你就可以使用poi实现批量导入功能了。你可以根据具体的需求进行相应的调整和扩展。 #### 引用[.reference_title] - *1* *2* *3* [SpringBoot项目+Echart数据展示+poi 实现批量导入导出]...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值