Note the problems encountered in using Jxls in the project
Cannot load XLS transformer. Please make sure a Transformer implementation is in classpath
Check whether components such as easyexcel are introduced into the project
if so, it needs to be excluded
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>easyexcel</artifactId>
<version>2.2.10</version>
<exclusions>
<exclusion>
<artifactId>poi</artifactId>
<groupId>org.apache.poi</groupId>
</exclusion>
<exclusion>
<artifactId>poi-ooxml</artifactId>
<groupId>org.apache.poi</groupId>
</exclusion>
<exclusion>
<artifactId>poi-ooxml-schemas</artifactId>
<groupId>org.apache.poi</groupId>
</exclusion>
</exclusions>
</dependency>
Then
the POI component 4 version is introduced
<dependency>
<groupId>org.apache.poi</groupId>
<artifactId>poi</artifactId>
<version>4.1.2</version>
</dependency>
<dependency>
<groupId>org.apache.poi</groupId>
<artifactId>poi-ooxml</artifactId>
<version>4.1.2</version>
</dependency>
<dependency>
<groupId>org.apache.poi</groupId>
<artifactId>poi-ooxml-schemas</artifactId>
<version>4.1.2</version>
</dependency>
Because the project is iterative, complex excel is exported. Easyexcel can not meet the requirements. You can consider processing complex logic in the form of Jxls template.
it can solve the function of Excel processing by block, horizontal and column
official website: http://jxls.sourceforge.net/
In theory, it is not recommended to use several excel components at the same time. The idea plug-in Maven helper is recommended here to facilitate conflict handling.
When a problem is inexplicable and can not be solved by how to change it, see if there is a package conflict and if there is a problem with the network itself.
Read More:
- [Solved] The Bean Validation API is on the classpath but no implementation could be found
- [Solved] Spring Boot Startup Error: Failed to load property source from location ‘classpath:/application-dev.yml‘
- [Fixed] Disgusting bug Error:Failed to Load project configuration: cannot parse filemessage: content is not allowed in the preface.
- The thread implementation of timer in Java
- [Solved] Invocation of init method failed; nested exception is java.lang.NoSuchMethodError:
- Error in make when installing redis6.0 in centos7
- Implementation of retrial mechanism in Java
- C++: Implementation of multi-channel IO transfer with select
- [2022 New Solution] SLF4J: Failed to load class “org.slf4j.impl.StaticLoggerBinder
- Java implementation of inputsteam to Base64
- Java callback function implementation case
- DevTools failed to load SourceMap Could not load content [Solved]
- C language: Implementation of dynamic array initialization, insertion, traversal, deletion and destruction
- Ali easyexcel error: org.apache.poi.ss.usermodel.font.setbold (z) V
- [Solved] M1 Chip MacBook Pro Error: snappy-java FAILED_TO_LOAD_NATIVE_LIBRARY
- Java error: unable to find or load main class (package name in source file)
- Caused by: java.lang.IllegalStateException (How to Fix)
- Java: How to use itext to export PDF text absolute positioning (implementation method)
- [Solved] ‘build.plugins.plugin.version‘ for org.springframework.boot:spring-boot-maven-plugin is missing.
- [Solved] nested exception is java.lang.NoClassDefFoundError: javax/xml/bind/DatatypeConverter