easypoi 表头数据导入_easypoi导出动态表头excel

easypoi导出动态表头excel

1: springBoot项目maven依赖：

cn.afterturn

easypoi-spring-boot-starter

4.1.2

根据自己的poi版本选择

cn.afterturn

easypoi-spring-boot-starter

3.3.0

测试导出(数据组装如下)：

@Testpublic voiddynaCol() {try{

List colList = new ArrayList();

ExcelExportEntity colEntity= new ExcelExportEntity("商品名称", "title");

colEntity.setNeedMerge(true);

colList.add(colEntity);

colEntity= new ExcelExportEntity("供应商", "supplier");

colEntity.setNeedMerge(true);

colList.add(colEntity);

ExcelExportEntity deliColGroup= new ExcelExportEntity("得力", "deli");

List deliColList = new ArrayList();

deliColList.add(new ExcelExportEntity("市场价", "orgPrice"));

deliColList.add(new ExcelExportEntity("专区价", "salePrice"));

deliColGroup.setList(deliColList);

colList.add(deliColGroup);

ExcelExportEntity jdColGroup= new ExcelExportEntity("京东", "jd");

List jdColList = new ArrayList();

jdColList.add(new ExcelExportEntity("市场价", "orgPrice"));

jdColList.add(new ExcelExportEntity("专区价", "salePrice"));

jdColGroup.setList(jdColList);

colList.add(jdColGroup);

List>