Jxls异常 Cannot load XLS transformer. Please make sure a Transformer impleme

错误：Cannot load XLS transformer. Please make sure a Transformer implementation is in classpath原因：这是 jxls 的版本升级2.4后需要额外导入其他依赖<dependency><groupId>org.jxls</groupId><artifactId>j

k55

3824人浏览 · 2022-01-20 17:21:14

k55 · 2022-01-20 17:21:14 发布

在这里插入图片描述

错误：Cannot load XLS transformer. Please make sure a Transformer implementation is in classpath
原因： 这是 jxls 的版本升级2.4后需要额外导入其他依赖

在这里插入图片描述
还要在plugins中加上以下插件

 <plugin>
              <groupId>org.apache.maven.plugins</groupId>
              <artifactId>maven-resources-plugin</artifactId>
              <configuration>
                  <nonFilteredFileExtensions>
                      <nonFilteredFileExtension>xlsx</nonFilteredFileExtension>
                  </nonFilteredFileExtensions>
              </configuration>
          </plugin>

以下就是全部依赖

  <!--excel生成工具-->
        <dependency>
            <groupId>org.jxls</groupId>
            <artifactId>jxls-jexcel</artifactId>
            <version>1.0.9</version>
        </dependency>
        <dependency>
            <groupId>org.jxls</groupId>
            <artifactId>jxls-poi</artifactId>
            <version>1.0.14</version>
        </dependency>
        <dependency>
            <groupId>org.jxls</groupId>
            <artifactId>jxls</artifactId>
            <version>2.4.4</version>
        </dependency>

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