Cannot get a STRING value from a NUMERIC cell

原创

于 2024-08-21 17:12:56 发布 · 505 阅读

7 ·

CC 4.0 BY-SA版权

文章标签：

#windows

easyExcel 列合并时,只能是String的进行合并,用数值型的会在最后一行错:Cannot get a STRING value from a NUMERIC cell

SimpleDateFormat sdf = new SimpleDateFormat("yyyy年MM月dd日");
String oneHead = "***平台" + sdf.format(bo.getSendBeginDate()) + "至" + sdf.format(bo.getSendEndDate()) + "所有活动数据汇总表（" + bo.getOrgName() + "）";
String sheetName = sdf.format(bo.getSendBeginDate()) + "至" + sdf.format(bo.getSendEndDate()) + "汇总";
String twoHead = "统计区间:" + sdf.format(bo.getSendBeginDate()) + "-" + sdf.format(bo.getSendEndDate());
List<vo> list = service.queryList(bo);

//ExcelUtil.exportExcel(list, title, vo.class, response);普通导出
String filename = ExcelUtil.encodingFilename(oneHead);
FileUtils.setAttachmentResponseHeader(response, filename);
response