关于动态导出Excel

导出Excel表用到的组件POI，动态的获取每个列数，然后将每个行数的值累加求和。代码如下

controller层代码

try {    XSSFCell cell = null;    String sheetName="督查统计数据总和";    String fileName =new SimpleDateFormat("yyyyMMddHHmmss").format(new Date())+sheetName + ".xlsx";    // 第一步，创建一个webbook，对应一个Excel文件    XSSFWorkbook xb = new XSSFWorkbook();    // 第二步，在webbook中添加一个sheet,对应Excel文件中的sheet    XSSFSheet sheet = xb.createSheet(sheetName);    // 第三步，在sheet中添加表头第0行,注意老版本poi对Excel的行数列数有限制short    XSSFRow row = sheet.createRow(0);    // 第四步，创建单元格，并设置值表头 设置表头居中    XSSFCellStyle style = xb.createCellStyle();    style.setAlignment(XSSFCellStyle.ALIGN_CENTER); // 创建一个居中格式    List<SupdataSend> list=supdataSendService.getSupdatasendid(supdataSend.getId());    List<String> list1= new ArrayList<String>();    list1.add("部门名称");    list1.add("上报次数");    for (SupdataSend supdataSend1:list){        list1.add(supdataSend1.getDataName());    }    for (int i = 0; i < list1.size(); i++) {        cell = row.createCell(i);        cell.setCellValue(list1.get(i));        cell.setCellStyle(style);    }    List<SupdataSend> sendList=supdataSendService.getListImport(supdataSend.getId());    for (int i=0;i<sendList.size();i++){        row = sheet.createRow(i+1);        if (sendList.get(i).getReceiveId()!=null){            row.createCell(0).setCellValue(sendList.get(i).getReceiveId());        }else {            row.createCell(0).setCellValue("");        }        if (sendList.get(i).getReportNum()!=null){            row.createCell(1).setCellValue(sendList.get(i).getReportNum());        }else {            row.createCell(1).setCellValue("0");        }        for (int j=0;j<list.size();j++){

//根据行和列统计总数            Double sumvalue= supdataValSonService.getBydataName(list.get(j).getDataName(),sendList.get(i).getRemark());            if (sumvalue!=null){                row.createCell(j+2).setCellValue(sumvalue);            }else {                row.createCell(j+2).setCellValue("0");            }        }    }

 try {        this.setResponseHeader(response, fileName);        OutputStream os = response.getOutputStream();        xb.write(os);        os.flush();        os.close();    } catch (Exception e) {        e.printStackTrace();    }} catch (Exception e) {    addMessage(redirectAttributes, "导出督查统计记录失败！失败信息：" + e.getMessage());}

public void setResponseHeader(HttpServletResponse response, String fileName) {    try {        try {            fileName = new String(fileName.getBytes(), "ISO8859-1");        } catch (UnsupportedEncodingException e) {            e.printStackTrace();        }        response.setContentType("application/octet-stream;charset=ISO8859-1");        response.setHeader("Content-Disposition", "attachment;filename=" + fileName);        response.addHeader("Pargam", "no-cache");        response.addHeader("Cache-Control", "no-cache");    } catch (Exception ex) {        ex.printStackTrace();    }}
service层代码

public List<SupdataSend> getListImport(String id){   //List<SupdataField> fieldList=supdataFieldDao.getSupdataSendid(id);   List<SupdataSend> list1= new ArrayList<SupdataSend>();   List<SupdataReceive> list=supdataReceiveDao.getSupdatasendId(id);   for (SupdataReceive supdataReceive:list){      SupdataSend supdataSend= new SupdataSend();      supdataSend.setReceiveId(supdataReceive.getOfficeName());      supdataSend.setReportNum(supdataReceive.getReportNum());      //封装单位的ID      supdataSend.setRemark(supdataReceive.getRemark());      //supdataSend.setList(list2);      list1.add(supdataSend);   }   return list1;}