功能:导出Excel ,单元格合并
效果图:
代码主要分为三块:
第一部分:数据获取,标题确定,合并内容确定
* 督查大队工作周报导出
*
* @param vo
*/
@Override
public Result workReportExcel(AssessWorkReportVo vo) throws IOException {
if(CollectionUtils.isEmpty(vo.getReportDTOList())){
return Result.error("请先查询再导出");
}
// 标题
String[] title ={"问题来源","单号","日期","具体地址","存在问题","整改情况","备注"};
// 数据来源
String[][] content =new String[vo.getReportDTOList().size()][title.length];
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
for(int i=0;i<vo.getReportDTOList().size();i++){
AssessWorkReportDTO dto = vo.getReportDTOList().get(i);
// 数据为null时 记录为空字符串
content[i][0] = dto.getSource() !=null?dto.getSource():"";
content[i][1] = dto.getCode()!=null?dto.getCode():"";
content[i][2] =dto.getCreateTime()!=null?sdf.format(dto.getCreateTime()):"";
content[i][3] = dto.getAddress()!=null?dto.getAddress():"";
content[i][4] = dto.getProblems()!=null?dto.getProblems():"";
content[i][5] = dto.getState()!=null?dto.getState():"";
content[i][6] = dto.getRemark(