Excel导出时文件中没有内容，表格是空的，并且后台抛出了下面的错误：No converter for [class com.common.dto.CommonResult] with preset Content-Type 'application/vnd.ms；error is sun.awt.FontConfiguration.getVersion

<<错误信息一>>

Excel导出时文件中没有内容，表格是空的，并且后台抛出了下面的错误：

2023-09-14 09:48:59.876 WARN 7 --- [http-nio-8096-exec-3] .m.m.a.ExceptionHandlerExceptionResolver : Failure in @ExceptionHandler com.cscecnf.common.exception.GlobalExceptionHandler#exception(Exception, HttpServletRequest)

org.springframework.http.converter.HttpMessageNotWritableException:
No converter for [class com.cscecnf.common.dto.CommonResult] with preset Content-Type 'application/vnd.ms-excel;charset=utf-8'
at org.springframework.web.servlet.mvc.method.annotation.AbstractMessageConverterMethodProcessor.writeWithMessageConverters(AbstractMessageConverterMethodProcessor.java:309)
at org.springframework.web.servlet.mvc.method.annotation.RequestResponseBodyMethodProcessor.handleReturnValue(RequestResponseBodyMethodProcessor.java:181)
at org.springframework.web.method.support.HandlerMethodReturnValueHandlerComposite.handleReturnValue(HandlerMethodReturnValueHandlerComposite.java:82)
at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:123)
at org.springframework.web.servlet.mvc.method.annotation.ExceptionHandlerExceptionResolver.doResolveHandlerMethodException(ExceptionHandlerExceptionResolver.java:407)
at org.springframework.web.servlet.handler.AbstractHandlerMethodExceptionResolver.doResolveException(AbstractHandlerMethodExceptionResolver.java:61)
at org.springframework.web.servlet.handler.AbstractHandlerExceptionResolver.resolveException(AbstractHandlerExceptionResolver.java:141)
at org.springframework.web.servlet.handler.HandlerExceptionResolverComposite.resolveException(HandlerExceptionResolverComposite.java:80)
at org.springframework.web.servlet.DispatcherServlet.processHandlerException(DispatcherServlet.java:1300)
at org.springframework.web.servlet.DispatcherServlet.processDispatchResult(DispatcherServlet.java:1111)
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1057)
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:943)
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006)
at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:909)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:665)
at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:750)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:712)
at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:580)
at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:516)
at org.apache.catalina.core.StandardHostValve.custom(StandardHostValve.java:388)
at org.apache.catalina.core.StandardHostValve.status(StandardHostValve.java:253)
at org.apache.catalina.core.StandardHostValve.throwable(StandardHostValve.java:348)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:173)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343)
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:373)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:868)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1594)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:748)

 

1、controller层返回值CommonResult 改为void

@PostMapping(value = "/export")
@ApiOperation(value = "导出")
public void export(@RequestBody WorkDataExportDTO exportDTO, HttpServletResponse response) {
    log.info("WorkDataController - export, exportDTO is {}", JSONObject.toJSONString(exportDTO));
    workDataService.export(exportDTO,response);
    return CommonResult.ok();
}

<<错误信息二>>
修改为void后，导出的时候还会报另一个错误：sun.awt.FontConfiguration.getVersion(FontConfiguration.java:1264)

2023-09-14 10:39:43.988 ERROR 7 --- [http-nio-8096-exec-8] c.c.t.c.s.impl.WorkDataCraneServiceImpl : === WorkDataCraneServiceImpl - export, error is sun.awt.FontConfiguration.getVersion(FontConfiguration.java:1264)
2023-09-14 10:39:43.989 INFO 7 --- [http-nio-8096-exec-8] com.cscecnf.common.config.LogAop : 返回 : null

这个错误是因为部署到Linux服务器上面的时候，缺少相应的的字体导致的。

2、所以，需要在运行docker容器的Dockerfile文件中增加下面两行配置；

#配置软件源
RUN sed -i 's/dl-cdn.alpinelinux.org/mirrors.ustc.edu.cn/g' /etc/apk/repositories
#解决openjdk:8-jdk-alpine缺少字体导致Easyexcel无法导出的问题
RUN apk --update add fontconfig ttf-dejavu

再次运行发包后就可以正常导出Excel表格的数据了。