介绍
java操作excel文件最经典的是POI,但是其api 较多,代码量巨大,反复重复
excel4j ap则简洁太多,利用pojo建模,利用注解进行标识@ExcelField(title = “URL”)
准备条件
1、引入jar支持
<dependency>
<groupId>com.github.crab2died</groupId>
<artifactId>Excel4J</artifactId>
<version>3.0.0-Alpha</version>
</dependency>
pom.xml
<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 https://maven.apache.org/xsd/maven-4.0.0.xsd">
<modelVersion>4.0.0</modelVersion>
<parent>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-parent</artifactId>
<version>2.5.6</version>
<relativePath /> <!-- lookup parent from repository -->
</parent>
<groupId>cn.tedu</groupId>
<artifactId>zp</artifactId>
<version>0.0.1-SNAPSHOT</version&g