Hutool工具包导出Excel文件异常 You need to add dependency of poi-ooxml to your project

Hutool工具包导出Excel文件异常 You need to add dependency of poi-ooxml to your project

异常信息:

1
2
3
4
5
6
7
8
cn.hutool.core.exceptions.DependencyException: You need to add dependency of 'poi-ooxml' to your project, and version >= 3.17
at cn.hutool.poi.excel.ExcelUtil.getWriter(ExcelUtil.java:376)
at cn.pconline.pcloud.admin.controller.train.ExamController.downRankList(ExamController.java:364)
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:498)
省略其他。。。。

解决方案:

提示很明确啊,你需要引入poi-ooxml库,版本>=3.17,具体见文档:

https://www.hutool.cn/docs/#/poi/%E6%A6%82%E8%BF%B0

使用Hutool工具包导出Excel例子

贴一个使用Hutool工具导出excel的例子,方便下次复制

  • 1.添加pom依赖
1
2
3
4
5
6
7
8
9
10
11
12
<!--Hutool工具包-->
<dependency>
<groupId>cn.hutool</groupId>
<artifactId>hutool-all</artifactId>
<version>4.5.10</version>
</dependency>
<!--Hutool工具ExcelUtil依赖这个 https://mvnrepository.com/artifact/org.apache.poi/poi-ooxml-->
<dependency>
<groupId>org.apache.poi</groupId>
<artifactId>poi-ooxml</artifactId>
<version>4.1.0</version>
</dependency>
  • 2.请求代码
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
 /**
* 导出
*
* @param request
* @param response
*/
@RequestMapping(value = "/student/export.do")
public void export(HttpServletRequest request, HttpServletResponse response) {
try {
List<Student> list = studentService.getlist(Student.class);

String fileName = "student-" + new SimpleDateFormat("yyyy-MM-dd").format(new Date());
ServletOutputStream out = response.getOutputStream();
response.setContentType("multipart/form-data");
response.setCharacterEncoding("utf-8");
response.setHeader("Content-disposition", "attachment;filename=" + URLEncoder.encode(fileName, "UTF-8") + ".xlsx");

List<String> header = CollUtil.newArrayList("名次", "员工名称", "分数", "耗时");
ExcelWriter excelWriter = ExcelUtil.getWriter(true);
excelWriter.writeHeadRow(header);
excelWriter.write(getListRow(list));
excelWriter.flush(response.getOutputStream());
excelWriter.close();
out.flush();
} catch (Exception e) {
e.printStackTrace();
}
}

private List<List<String>> getListRow(List<Student> students) {
List<List<String>> rows = new ArrayList<>();
students.stream().filter(student -> students != null).forEach(student -> {
rows.add(new ArrayList<String>() {{
add(student.getNo());
add(student.getName());
add(student.getScore());
add(student.getTime());

}});
});
return rows;
}
-------------已经触及底线 感谢您的阅读-------------

本文标题:Hutool工具包导出Excel文件异常 You need to add dependency of poi-ooxml to your project

文章作者:趙小傑~~

发布时间:2019年11月27日 - 17:37:44

最后更新:2019年11月28日 - 22:04:51

原始链接:https://cnsyear.com/posts/5e7133e9.html

许可协议: 署名-非商业性使用-禁止演绎 4.0 国际 转载请保留原文链接及作者。

0%