pig-mesh / excel-spring-boot-starter Goto Github PK

This issue lists Renovate updates and detected dependencies. Read the Dependency Dashboard docs to learn more.

This repository currently has no open or pending branches.

Detected dependencies

• Check this box to trigger a request for Renovate to run again on this repository

模板的excel文件要放那里

在#48中修复了一些问题，但貌似没有更新到maven，能否更新一下呢。需要使用这个问题，万分感谢

当使用Spel动态指定导出excel的文件名时，
@ResponseExcel(name = "#{T(java.lang.Math).PI * 80}", sheets = @sheet(sheetName = "导出数据"))

报错“org.springframework.expression.spel.SpelParseException: Expression [#{T(java.lang.Math).PI * 80}] @1: EL1043E: Unexpected token. Expected 'identifier' but was 'lcurly({)'”

就以https://github.com/pig-mesh/pig这个项目中导入用户的接口为例
模板如下

2 4 行在数据库中已经存在相同的用户名
3 行在校验的时候就不通过了
所以实际上在校验的时候会有个3行提示手机号等不能为空的错误
然后只有2 4行去到了server中,在server中进行校验并插入
然而2 4行在server中校验错误是根据传入的list的下标加2来提示的错误行数
就造成了提示2 3行用户名重复
最终返回给前端的效果就是

com.alibaba.excel.exception.ExcelGenerateException: java.lang.InternalError: java.lang.reflect.InvocationTargetException] with root cause
java.lang.NullPointerException: Cannot load from short array because "sun.awt.FontConfiguration.head" is null
at java.desktop/sun.awt.FontConfiguration.getVersion(FontConfiguration.java:1264)
at java.desktop/sun.awt.FontConfiguration.readFontConfigFile(FontConfiguration.java:224)
at java.desktop/sun.awt.FontConfiguration.init(FontConfiguration.java:106)
at java.desktop/sun.awt.X11FontManager.createFontConfiguration(X11FontManager.java:706)
at java.desktop/sun.font.SunFontManager$2.run(SunFontManager.java:358)
at java.desktop/sun.font.SunFontManager$2.run(SunFontManager.java:315)
at java.base/java.security.AccessController.doPrivileged(AccessController.java:318)
at java.desktop/sun.font.SunFontManager.(SunFontManager.java:315)
at java.desktop/sun.awt.FcFontManager.(FcFontManager.java:35)
at java.desktop/sun.awt.X11FontManager.(X11FontManager.java:56)
at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:77)
at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.base/java.lang.reflect.Constructor.newInstanceWithCaller(Constructor.java:499)
at java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:480)
at java.desktop/sun.font.FontManagerFactory$1.run(FontManagerFactory.java:85)
at java.base/java.security.AccessController.doPrivileged(AccessController.java:318)
at java.desktop/sun.font.FontManagerFactory.getInstance(FontManagerFactory.java:75)
at java.desktop/java.awt.Font.getFont2D(Font.java:526)
at java.desktop/java.awt.Font.canDisplayUpTo(Font.java:2282)
at java.desktop/java.awt.font.TextLayout.singleFont(TextLayout.java:469)
at java.desktop/java.awt.font.TextLayout.(TextLayout.java:530)
at org.apache.poi.ss.util.SheetUtil.getDefaultCharWidth(SheetUtil.java:285)
at org.apache.poi.xssf.streaming.AutoSizeColumnTracker.(AutoSizeColumnTracker.java:117)
at org.apache.poi.xssf.streaming.SXSSFSheet.(SXSSFSheet.java:89)
at org.apache.poi.xssf.streaming.SXSSFWorkbook.createAndRegisterSXSSFSheet(SXSSFWorkbook.java:703)
at org.apache.poi.xssf.streaming.SXSSFWorkbook.createSheet(SXSSFWorkbook.java:722)
at org.apache.poi.xssf.streaming.SXSSFWorkbook.createSheet(SXSSFWorkbook.java:100)
at com.alibaba.excel.util.WorkBookUtil.createSheet(WorkBookUtil.java:84)
at com.alibaba.excel.context.WriteContextImpl.createSheet(WriteContextImpl.java:223)
at com.alibaba.excel.context.WriteContextImpl.initSheet(WriteContextImpl.java:203)
at com.alibaba.excel.context.WriteContextImpl.currentSheet(WriteContextImpl.java:135)
at com.alibaba.excel.write.ExcelBuilderImpl.addContent(ExcelBuilderImpl.java:54)
at com.alibaba.excel.ExcelWriter.write(ExcelWriter.java:73)
at com.alibaba.excel.ExcelWriter.write(ExcelWriter.java:50)
at com.pig4cloud.plugin.excel.handler.SingleSheetWriteHandler.write(SingleSheetWriteHandler.java:69)
at com.pig4cloud.plugin.excel.handler.AbstractSheetWriteHandler.export(AbstractSheetWriteHandler.java:97)
at com.pig4cloud.plugin.excel.aop.ResponseExcelReturnValueHandler.lambda$handleReturnValue$1(ResponseExcelReturnValueHandler.java:55)
at java.base/java.util.Optional.ifPresent(Optional.java:178)
at com.pig4cloud.plugin.excel.aop.ResponseExcelReturnValueHandler.handleReturnValue(ResponseExcelReturnValueHandler.java:55)
at org.springframework.web.method.support.HandlerMethodReturnValueHandlerComposite.handleReturnValue(HandlerMethodReturnValueHandlerComposite.java:78)
at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:135)
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:884)
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:797)
at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1080)
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:973)
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1010)
at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:913)
at jakarta.servlet.http.HttpServlet.service(HttpServlet.java:731)
at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:884)
at jakarta.servlet.http.HttpServlet.service(HttpServlet.java:814)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:223)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:158)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:185)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:158)
at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:100)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:116)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:185)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:158)
at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:116)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:185)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:158)
at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:116)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:185)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:158)
at com.aspire.ums.cmdb.config.filter.RequestWrapperFilter.doFilter(RequestWrapperFilter.java:67)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:185)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:158)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:177)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:542)
at org.apache.catalina.core.StandardHostValve.sw$original$invoke$a1l9ol1(StandardHostValve.java:119)
at org.apache.catalina.core.StandardHostValve.sw$original$invoke$a1l9ol1$accessor$sw$p8ebm33(StandardHostValve.java)
at org.apache.catalina.core.StandardHostValve$sw$auxiliary$i5j7rt3.call(Unknown Source)
at org.apache.skywalking.apm.agent.core.plugin.interceptor.enhance.InstMethodsInter.intercept(InstMethodsInter.java:86)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:357)
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:400)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:859)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1734)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52)
at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)
at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.base/java.lang.Thread.run(Thread.java:833)

arrayBuffer和blob在开发环境正常显示，但是切换到线上后返回空数据，chrome显示failed to load response data

RT

主要耗时在org.springframework.cglib.proxy.MethodInterceptor:intercept()

使用模板导出时：
java.io.FileNotFoundException: class path resource [excel/demo.xlxs] cannot be opened because it does not exist

如：status：1：启用，0：禁用
1：下载模板时，根据数据字典的标签生成下拉，启用，禁用
2：上传时，根据字符串，映射成数字1,0
希望能提供一个字典的处理接口

怎样校验导入的表头

高级填充那块，模板文件都木有，是否支持复杂模板导出呢

问题说明

查看源码，定义了SingleSheetWriteHandler和ManySheetWriteHandler来进行相应导出操作，里面的support方法来判断使用哪一个类。由于数据长度为零，两次support调用都返回false，导致没有文件导出。

数据为空时不进行导出，不太符合一般的业务逻辑，这种情况下导出空的文件更符合预期。希望维护者能更新这一块的逻辑，或让用户通过参数自定义导出行为。

临时解决方法

如果想临时修改这部分逻辑，可以实现自定义的SingleSheetWriteHandler，修改默认support实现。

代码示例

@Component
public class MySingleSheetWriteHandler extends SingleSheetWriteHandler {

    public MySingleSheetWriteHandler(ExcelConfigProperties configProperties,
            ObjectProvider<List<Converter<?>>> converterProvider, WriterBuilderEnhancer excelWriterBuilderEnhance) {
        super(configProperties, converterProvider, excelWriterBuilderEnhance);
    }

    @Override
    public boolean support(Object obj) {
        if (obj instanceof List) {
            List<?> objList = (List<?>) obj;

            if (objList.isEmpty()) {
                return true;
            }

            return !(objList.get(0) instanceof List);
        } else {
            throw new ExcelException("@ResponseExcel 返回值必须为List类型");
        }
    }

}

导出的文件中文名经过encode编码
如：@ResponseExcel(name = "中文名")
导出的文件名为：%E4%B8%AD%E6%96%87%E5%90%8D

查询后定位到如下位置：
com.pig4cloud.plugin.excel.handler.AbstractSheetWriteHandler
export方法内的fileName参数导致此问题

https://www.yuque.com/easyexcel/doc/fill

我照着给的用例去跑

版本：0.0.5

1.2.8是可用版本吗

README中的导出效果:

Username 折行也太丑了, 实际确实和文档上的效果一样.但是能不能和 easypoi 一样来个 width 属性, 让 userName表头不要折行.

Description:
Parameter 0 of constructor in com.pig4cloud.plugin.excel.ResponseExcelAutoConfiguration required a single bean, but 2 were found:

• requestMappingHandlerAdapter: defined by method 'requestMappingHandlerAdapter' in class path resource [org/springframework/boot/autoconfigure/web/servlet/WebMvcAutoConfiguration$EnableWebMvcConfiguration.class]
• repositoryExporterHandlerAdapter: defined by method 'repositoryExporterHandlerAdapter' in class path resource [org/springframework/data/rest/webmvc/config/RepositoryRestMvcConfiguration.class]

导出方法，暴露一下Content-Disposition头，不然在knife4j中可能显示导出为knife4j.txt
response.addHeader(HttpHeaders.ACCESS_CONTROL_EXPOSE_HEADERS, HttpHeaders.CONTENT_DISPOSITION);

java.lang.IndexOutOfBoundsException: Index 0 out of bounds for length 0 at java.base/jdk.internal.util.Preconditions.outOfBounds(Preconditions.java:64) at java.base/jdk.internal.util.Preconditions.outOfBoundsCheckIndex(Preconditions.java:70) at java.base/jdk.internal.util.Preconditions.checkIndex(Preconditions.java:248) at java.base/java.util.Objects.checkIndex(Objects.java:372) at java.base/java.util.ArrayList.get(ArrayList.java:459) at com.pig4cloud.plugin.excel.handler.ManySheetWriteHandler.write(ManySheetWriteHandler.java:55)

导出文件支持自定义中文名称吗？

https://www.91mszl.com/zhangwuji/article/details/1479