工作几年,每年都有java数据导出Excel的需求,从最初的POI到公司封装的工具再到阿里的EasyExcel。总是有这个那个的小痛点,最近发现easypoi比较满足工作需求,可以很好的导出数据并处理单元格合并的问题,perfect!!!
这是entity类,注解的mergeVertical是纵向合并内容相同的单元格,默认是false
import cn.afterturn.easypoi.excel.annotation.Excel;
import lombok.Data;
import java.io.Serializable;
@Data
public class UserEntity implements Serializable {
private static final long serialVersionUID = 1L;
private String idx;
@Excel(name = "籍贯", mergeVertical = true, width = 50)
private String nativeStr;
@Excel(name = "姓名", width = 20)
private String userName;
@Excel(name = "年龄", needMerge = true)
private int age;
@Excel(name = "地址", width = 50)
private String addr;
}
测试类:
import cn.after