代码
List<WleUserSaleVo> list = reportWleSaleService.wleUserSaleList(null, vo);
ExcelWriter excelWriter = cn.hutool.poi.excel.ExcelUtil.getBigWriter();
excelWriter.addHeaderAlias("username", "用户名称");
excelWriter.addHeaderAlias("userPhone", "用户手机");
excelWriter.addHeaderAlias("cityName", "城市名称");
excelWriter.addHeaderAlias("saleAmt", "交易金额");
excelWriter.addHeaderAlias("realSaleAmt", "实际交易金额");
excelWriter.addHeaderAlias("avgOrderAmt", "平均客单价");
excelWriter.addHeaderAlias("orderCnt", "订单数");
excelWriter.setOnlyAlias(true);
excelWriter.write(list);
try {
response.reset();
response.setContentType("application/vnd.ms-excel;charset=utf-8");
response.setHeader("Content-Disposition", "attachment;filename=" + new String(( "团批用户购买力报表.xls").getBytes(), "iso-8859-1"));
ServletOutputStream out = response.getOutputStream();
excelWriter.flush(out, true);
excelWriter.close();
} catch (Exception e) {
e.printStackTrace();
}
问题以及排查思路
1, 例如 username 这列明明list 里面有数据, 确没有输出,
2, 首先检查 list 中的 WleUserSaleVo 有没有 username 的get方法
3, 第一行数据有没有username, 第一行没有数据, 后面的有数据也不会写入