EasyExcel是一款开源的Java处理Excel文件的工具库,它提供了简单易用的API,可以方便地读取、写入和操作Excel文件。合并表头很简单,只需要在对象注解加上相同内容即可,如下
@Data
@NoArgsConstructor
@AllArgsConstructor
@Builder
public class User implements Serializable {
@ExcelProperty(value = {"用户基本信息","用户名"},index = 0)
private String userName;
@ExcelProperty(value = {"用户基本信息","年龄"},index = 1)
private Integer age;
@ExcelProperty(value = {"用户基本信息","地址"} ,index = 2)
private String address;
@ExcelProperty(value = {"用户基本信息","生日"},index = 3)
//注意:日期格式注解由alibaba.excel提供
// @DateTimeFormat("yyyy-MM-dd HH:mm")
private Date birthday;
}