包含多个小型 Spring/工具模块的单体仓库,用于常见开发任务。
| English | 中文 |
<dependency>
<groupId>org.springtools</groupId>
<artifactId>spring-excel-mapper</artifactId>
<version>1.0.0-SNAPSHOT</version>
</dependency>
// 1. 使用注解定义模型(支持正则、数值范围等校验)
@ExcelSheet
@ExcelRow(startRowIndex = 1)
public class StudentExcelModel {
@ExcelColumn(col = "A", required = true)
public String name;
@ExcelColumn(col = "B", regex = "^[\\w-\\.]+@([\\w-]+\\.)+[\\w-]{2,4}$")
public String email;
@ExcelColumn(col = "C", min = 18, max = 65)
public Integer age;
}
// 2. 解析 Excel(带验证)
Workbook workbook = WorkbookFactory.create(inputStream);
ImportResult<StudentExcelModel> result =
ExcelMapper.parseWorkbookWithResult(workbook, StudentExcelModel.class, false);
// 3. 导出到模板(保留样式)
Sheet sheet = workbook.getSheet("Students");
ExcelExporter.fillTableRows(sheet, 1, result.getSuccessList(), StudentExcelModel.class);
查看使用模式了解详细示例。
# 构建所有模块
mvn clean package
# 构建特定模块
mvn -pl spring-excel-mapper -am package
# 运行示例应用
mvn -pl spring-tools-simples spring-boot:run