在使用EasyExcel导出时生成Excel文件时文件创建成功,但没有任何数据,包括列名
Failed to complete request: org.springframework.web.util.NestedServletException: Handler dispatch failed; nested exception is java.lang.NoSuchMethodError: com.alibaba.excel.write.builder.ExcelWriterSheetBuilder.doWrite(Ljava/util/Collection;)V
@RequestMapping("print")
public String downloadFailedUsingJson(@RequestBody List<Brancht> m1, HttpServletResponse response) throws IOException {
// 这里注意 有同学反应使用swagger 会导致各种问题,请直接用浏览器或者用postman
System.out.println("===========");
System.out.println(m1);
try {
response.setContentType("application/vnd.openxmlformats-officedocument.spreadsheetml.sheet");
response.setCharacterEncoding("utf-8");
System.out.println(4);
// 这里需要设置不关闭流
String fileName = "D:\\" + "入库记录" + System.currentTimeMillis() + ".xlsx";
System.out.println(3);
System.out.println(m1);
EasyExcel.write(fileName, Brancht.class).autoCloseStream(Boolean.FALSE).sheet("入库记录").doWrite(m1);
// EasyExcel.write(response.getOutputStream(), m1.get(0).getClass()).autoCloseStream(Boolean.FALSE).sheet("文物数据表")
// .doWrite(m1);
System.out.println(5);
//日志回显
logger.info("打印成功"+fileName);
System.out.println(6);
return ("打印成功"+fileName);
} catch (Exception e) {
// 重置response
response.reset();
response.setContentType("application/json");
response.setCharacterEncoding("utf-8");
Map<String, String> map = MapUtils.newHashMap();
map.put("status", "failure");
map.put("message", "下载文件失败" + e.getMessage());
response.getWriter().println(JSON.toJSONString(map));
//日志回显
logger.error(JSON.toJSONString(map));
return (JSON.toJSONString(map));
}