导出excel类型转换
Map headmap = new LinkedHashMap<String, String>(); headmap.put("createtime", "日期"); headmap.put("orderno", "案件号"); headmap.put("vin", "vin码"); headmap.put("nickname", "用户姓名"); headmap.put("orderno", "案件号"); headmap.put("province", "省"); headmap.put("city", "市"); headmap.put("user_address", "救援位置"); headmap.put("service_name", "服务项目"); headmap.put("distance", "救援里程"); headmap.put("order_status", "订单状态"); headmap.put("sign_time", "完成时间"); List<SysDictData> dictList = dict.getType("order_status"); Map statusMap = dictList.stream() .collect(Collectors.toMap(SysDictData::getDictValue, SysDictData::getDictLabel)); List<Map> data = sqlMapper.getOrderReport(map); data.forEach(o -> { String s = o.get("order_status").toString(); o.put("order_status", statusMap.get(s)); }); FileUtil.down(headmap, data);