excel导出（基于hutool）ExcelUtil.getWriter()的报错解决

最新推荐文章于 2023-06-07 15:38:03 发布
最新推荐文章于 2023-06-07 15:38:03 发布
阅读量3.7k 收藏
点赞数 1
分类专栏： java 文章标签： java 后端
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/kawayiyy123/article/details/121242677
版权

excel导出（基于hutool）ExcelUtil.getWriter()的报错解决

java.lang.NoClassDefFoundError: org/apache/poi/hssf/usermodel/HSSFWorkbook
	at cn.hutool.poi.excel.WorkbookUtil.createBook(WorkbookUtil.java:158) ~[hutool-all-5.6.3.jar:na]
	at cn.hutool.poi.excel.ExcelWriter.<init>(ExcelWriter.java:109) ~[hutool-all-5.6.3.jar:na]
	at cn.hutool.poi.excel.ExcelWriter.<init>(ExcelWriter.java:97) ~[hutool-all-5.6.3.jar:na]
	at cn.hutool.poi.excel.ExcelUtil.getWriter(ExcelUtil.java:400) ~[hutool-all-5.6.3.jar:na]
	at com.ylhl.pay.order.IncomeStatementController.exportIncomeReportList(UserController.java:63) ~[classes/:na]
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_271]
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:1.8.0_271]
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_271]
	at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_271]
	at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:190) ~[spring-web-5.2.13.RELEASE.jar:5.2.13.RELEASE]
	at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:138) ~[spring-web-5.2.13.RELEASE.jar:5.2.13.RELEASE]
	at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:105) ~[spring-webmvc-5.2.13.RELEASE.jar:5.2.13.RELEASE]
	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:878) ~[spring-webmvc-5.2.13.RELEASE.jar:5.2.13.RELEASE]
	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:792) ~[spring-webmvc-5.2.13.RELEASE.jar:5.2.13.RELEASE]
	at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87) ~[spring-webmvc-5.2.13.RELEASE.jar:5.2.13.RELEASE]
	at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1040) ~[spring-webmvc-5.2.13.RELEASE.jar:5.2.13.RELEASE]
	at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:943) ~[spring-webmvc-5.2.13.RELEASE.jar:5.2.13.RELEASE]
	at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006) ~[spring-webmvc-5.2.13.RELEASE.jar:5.2.13.RELEASE]
	at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:909) ~[spring-webmvc-5.2.13.RELEASE.jar:5.2.13.RELEASE]
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:652) ~[tomcat-embed-core-9.0.43.jar:4.0.FR]
	at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883) ~[spring-webmvc-5.2.13.RELEASE.jar:5.2.13.RELEASE]
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:733) ~[tomcat-embed-core-9.0.43.jar:4.0.FR]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227) ~[tomcat-embed-core-9.0.43.jar:9.0.43]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) ~[tomcat-embed-core-9.0.43.jar:9.0.43]
	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) ~[tomcat-embed-websocket-9.0.43.jar:9.0.43]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) ~[tomcat-embed-core-9.0.43.jar:9.0.43]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) ~[tomcat-embed-core-9.0.43.jar:9.0.43]
	at com.ylhl.pay.config.filter.ModifyParamFilter.doFilterInternal(ModifyParamFilter.java:59) ~[classes/:na]
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119) ~[spring-web-5.2.13.RELEASE.jar:5.2.13.RELEASE]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) ~[tomcat-embed-core-9.0.43.jar:9.0.43]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) ~[tomcat-embed-core-9.0.43.jar:9.0.43]
	at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:100) ~[spring-web-5.2.13.RELEASE.jar:5.2.13.RELEASE]
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119) ~[spring-web-5.2.13.RELEASE.jar:5.2.13.RELEASE]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) ~[tomcat-embed-core-9.0.43.jar:9.0.43]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) ~[tomcat-embed-core-9.0.43.jar:9.0.43]
	at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93) ~[spring-web-5.2.13.RELEASE.jar:5.2.13.RELEASE]
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119) ~[spring-web-5.2.13.RELEASE.jar:5.2.13.RELEASE]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) ~[tomcat-embed-core-9.0.43.jar:9.0.43]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) ~[tomcat-embed-core-9.0.43.jar:9.0.43]
	at org.springframework.boot.actuate.metrics.web.servlet.WebMvcMetricsFilter.doFilterInternal(WebMvcMetricsFilter.java:93) ~[spring-boot-actuator-2.3.9.RELEASE.jar:2.3.9.RELEASE]
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119) ~[spring-web-5.2.13.RELEASE.jar:5.2.13.RELEASE]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) ~[tomcat-embed-core-9.0.43.jar:9.0.43]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) ~[tomcat-embed-core-9.0.43.jar:9.0.43]
	at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201) ~[spring-web-5.2.13.RELEASE.jar:5.2.13.RELEASE]
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119) ~[spring-web-5.2.13.RELEASE.jar:5.2.13.RELEASE]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) ~[tomcat-embed-core-9.0.43.jar:9.0.43]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) ~[tomcat-embed-core-9.0.43.jar:9.0.43]
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202) ~[tomcat-embed-core-9.0.43.jar:9.0.43]
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97) [tomcat-embed-core-9.0.43.jar:9.0.43]
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:542) [tomcat-embed-core-9.0.43.jar:9.0.43]
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:143) [tomcat-embed-core-9.0.43.jar:9.0.43]
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) [tomcat-embed-core-9.0.43.jar:9.0.43]
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78) [tomcat-embed-core-9.0.43.jar:9.0.43]
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:346) [tomcat-embed-core-9.0.43.jar:9.0.43]
	at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:374) [tomcat-embed-core-9.0.43.jar:9.0.43]
	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) [tomcat-embed-core-9.0.43.jar:9.0.43]
	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:887) [tomcat-embed-core-9.0.43.jar:9.0.43]
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1684) [tomcat-embed-core-9.0.43.jar:9.0.43]
	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) [tomcat-embed-core-9.0.43.jar:9.0.43]
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [na:1.8.0_271]
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [na:1.8.0_271]
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) [tomcat-embed-core-9.0.43.jar:9.0.43]
	at java.lang.Thread.run(Thread.java:748) [na:1.8.0_271]

缺少依赖

<dependency>
    <groupId>org.apache.poi</groupId>
    <artifactId>poi-ooxml</artifactId>
    <version>4.1.2</version>
</dependency>

加入即可

离阳光更近一点
关注
  • 1
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 1
    评论
专栏目录
最新导入导出工具类ExcelUtil.java
09-17
最新导入导出工具类ExcelUtil.java
数据库信息用excel表格导出
m0_69733784的博客
05-30 187
设置响应头的response Content-Disposition值，告诉浏览器将文件下载到本地的保存名称为“日期.xls”。这段代码的功能分为两部分，第一部分是将列表数据导出为Excel文件，第二部分是将导出的文件响应给浏览器供用户下载。设置Excel文件的表头，并自定义表头的列名别名，即将Java实体类的属性名映射为Excel表头列名。总的来说，这段代码的功能就是将数据库中的用户列表信息导出成Excel文件并响应下载给用户。设置是否只输出自定义的表头别名，不输出Java实体类的属性名。
hutool ExcelUtil导出excel、读取excel内容
weixin_45003796的博客
12-29 8733
hutool导出excel、读取excel内容导出读取excel内容 ExcelUtil为操作Excel的工具类，包括封装的excel读取的ExcelReader对象，excel生成的ExcelWriter对象。
ExcelUtil.rar
03-19
java导出excel工具类，有需要的下载。支持单个sheet和多个sheet页的导出。
ExcelUtil.java
08-19
通用的Excel数据导入导出的java工具类，支持excel2003和excel2007
异常报错：Servlet.service() for servlet [dispatcherServlet] in context with path [] threw exception
Alian_auerua的博客
03-18 5万+
servlet service（）下报错
已解决异常：Servlet.service() for servlet [dispatcherServlet] in context with path [] threw exception
05-02 9万+
已解决异常：Servlet.service() for servlet [dispatcherServlet] in context with path [] threw exception
异常：Servlet.service() for servlet [dispatcherServlet] in context with path [] threw exception 已解决
热门推荐
Java Punk
11-21 35万+
既然和 DispatcherServlet 有关，那无非就是MVC的映射出了问题
servlet.service() for servlet [dispatcherservlet] in context with path [] th
计算机毕业论文源码，学生个人网页制作html源码。贴近用户做网络推广和互联网优化。
05-25 2万+
.Servlet.service() for servlet [dispatcherServlet] in context with path [] threw exception [Request processing failed; nested exception is org.springframework.web.client.ResourceAccessException: I/O error on GET request for "http://localhost/8081:user/1":
Servlet.service() for servlet [dispatcherServlet] in context with path [] threw exception [Request
weixin_47164204的博客
08-07 8万+
是因为：Servlet.service服务（对于路径为[]的上下文中的servlet[dispatcherServlet]，引发了异常[请求处理失败；嵌套异常为java.lang.NullPointerException]有根本原因。说明是上面url引发的错误（可能url不存在，所跳转的url可能与web项目的root路径（一般是项目名）冲突）；所以检查自己的url是否配对。...
excelUtil.zip
05-23
vue页面导入导出功能，简单实用,一键导入导出页面的表格
Hutool-ExcelUtil多Sheet页导出
qq_36972185的博客
08-06 2968
public void exportWritten(HttpServletResponse response, String projectKey) { //已填报计划表的组织 Set<Map<String,Object>> orgList = ccpOrgMapper.getWrittenOrg(projectKey); //内容 Set<Map<String,Object>> list1 =
Servlet.service() for servlet [dispatcherServlet] in context with path [] th报错
计算机毕业论文源码，学生个人网页制作html源码。贴近用户做网络推广和互联网优化。
08-31 9351
Servlet.service() for servlet [dispatcherServlet] in context with path [] th报错修改方法： 1、加上@Autowired注解。 2、当你检查了注解没有问题的时候，一定要先检查数据库连接，url是否写对，用户名，密码是否正确。这些常见事情往往是错误的源头。 可能出错的地方： 1.controller层没有加@ResponseBody 2.Service层实现类未添加注解@Autowired 3.@RestController使用成了
java读取excel表，生成可以生成当前excel表的java代码
最新发布
Jernnifer_mao的博客
06-07 1252
完整代码/***/// 生成java代码// 由于\\字符串会被识别为\,因此这里需要写四个\");");");");");j++) {");");");// 获取标题结构int i = 0;}else{// 起始行// 末尾行// 起始列// 末尾列cal++;i++;return map;// 按起始列排序。
Servlet.service() for servlet [dispatcherServlet] in context with path [] threw exception 很详细！！！
*** 喵桑_Rachel ***
07-14 6万+
Servlet.service() for servlet [dispatcherServlet] in context with path [] threw exception [Request processing failed; nested exception is com.suntang.common.exception.RRException: 用户账号已被占用] with root cause 首先验证一下三种情况是否都满足：我这里已经验证过以上三种情况了 问题分析：postman报错首先手
Servlet.service() for servlet [dispatcherServlet] in context with path [] threw exception
一个菜鸡的博客
05-16 1万+
在进行springboot和mybatis遇到了这个错误 Servlet.service() for servlet [dispatcherServlet] in context with path [] th 解决点：仔细检查配置是不是正确 1.主程序有没有扫描到包 2.检查@autowired 3.接口检查：有没有标注上@service和@Mapper ...
常见异常【一】TooManyResultsException
z132378的博客
08-31 6070
org.apache.ibatis.exceptions.TooManyResultsException: Expected one result (or null) to be returned by selectOne(), but found: 11 at org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(Defa...
错误解决：Servlet.service() for servlet [dispatcherServlet] in context with path [] threw exception......
m0_56426418的博客
04-01 7623
session相关错误解决
ExcelWriter writer = ExcelUtil.getWriter();如何设置中文自适应
06-02
你可以通过以下方式设置中文自适应： 1. 设置全局配置 ``` // 全局配置 Workbook workbook = writer.getWorkbook(); // 字体设置 Font font = workbook.createFont(); font.setFontName("微软雅黑"); // 自适应宽度 CellStyle style = workbook.createCellStyle(); style.setFont(font); style.setWrapText(true); style.setAlignment(HorizontalAlignment.CENTER); style.setVerticalAlignment(VerticalAlignment.CENTER); // 设置自适应宽度 writer.setColumnWidth(-1, true); ``` 2. 单元格设置 ``` // 单元格设置 CellStyle cellStyle = workbook.createCellStyle(); cellStyle.setFont(font); cellStyle.setWrapText(true); cellStyle.setAlignment(HorizontalAlignment.CENTER); cellStyle.setVerticalAlignment(VerticalAlignment.CENTER); // 写入内容 writer.merge(rowNum, rowNum, 0, 3, "中文自适应", cellStyle); ``` 这样设置之后，ExcelWriter 写入的内容就会自适应宽度，中文也能够正常显示。

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论 1
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值