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

@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> list = new ArrayList>();for (int i = 0; i < 10; i++) {

Map valMap = new HashMap();

valMap.put("title", "名称." +i);

valMap.put("supplier", "供应商." +i);

List> deliDetailList = new ArrayList>();for (int j = 0; j < 3; j++) {

Map deliValMap = new HashMap();

deliValMap.put("orgPrice", "得力.市场价." +j);

deliValMap.put("salePrice", "得力.专区价." +j);

deliDetailList.add(deliValMap);

}

valMap.put("deli", deliDetailList);

List> jdDetailList = new ArrayList>();for (int j = 0; j < 2; j++) {

Map jdValMap = new HashMap();

jdValMap.put("orgPrice", "京东.市场价." +j);

jdValMap.put("salePrice", "京东.专区价." +j);

jdDetailList.add(jdValMap);

}

valMap.put("jd", jdDetailList);

list.add(valMap);

}

Workbook workbook= ExcelExportUtil.exportExcel(new ExportParams("价格分析表", "数据"), colList,

list);

FileOutputStream fos= new FileOutputStream("D:/价格分析表.tt.xls");

workbook.write(fos);

fos.close();

}catch(FileNotFoundException e) {

e.printStackTrace();

}catch(IOException e) {

e.printStackTrace();

}

}