pio实现exelc文件写入返回

      //拿到过程id
        req.getParameter("id");
        List<Map<String,String>> columns = procedureFieldService.queryField(req.getParameter("id"));
        List<Map<String,String>> columnsDate = procedureService.queryFieldData(req.getParameter("id"));
        // 前置表头
        List preposition = new  ArrayList();
        //表头对应数据
        List prepositiondate = new  ArrayList();
        preposition.add("procedure_id");
        preposition.add("station_id");
        preposition.add("data_format");
        preposition.add("sn");
        preposition.add("t_index");
        preposition.add("temperature");
        preposition.add("model");
        preposition.add("lotnumber");
        preposition.add("operator");
//        preposition.add("date");
        preposition.add("sensor_type");
        preposition.add("range_lower");
        preposition.add("range_upper");
        preposition.add("output_lower");
        preposition.add("unit");
        preposition.add("qualified");
        preposition.add("data");
        prepositiondate.addAll(preposition);
        HSSFWorkbook wb = new HSSFWorkbook();
        HSSFSheet sheet=wb.createSheet("过称数据");
        HSSFCellStyle cellStyle = wb.createCellStyle();
        //设置标题样式
        HSSFCellStyle style = wb.createCellStyle();
        style.setAlignment(HorizontalAlignment.CENTER);   //设置居中样式
        style.setVerticalAlignment(VerticalAlignment.CENTER);
        //设置标题字体
        Font titleFont = wb.createFont();
        titleFont.setFontHeightInPoints((short) 14);
        style.setFont(titleFont);

        //设置值表头样式 设置表头居中
        HSSFCellStyle hssfCellStyle = wb.createCellStyle();
        hssfCellStyle.setAlignment(HorizontalAlignment.CENTER);   //设置居中样式
        hssfCellStyle.setBorderBottom(BorderStyle.THIN);
        hssfCellStyle.setBorderLeft(BorderStyle.THIN);
        hssfCellStyle.setBorderRight(BorderStyle.THIN);
        hssfCellStyle.setBorderTop(BorderStyle.THIN);

        //设置表内容样式
        //创建单元格，并设置值表头 设置表头居中
        HSSFCellStyle style1 = wb.createCellStyle();
        style1.setBorderBottom(BorderStyle.THIN);
        style1.setBorderLeft(BorderStyle.THIN);
        style1.setBorderRight(BorderStyle.THIN);
        style1.setBorderTop(BorderStyle.THIN);



//在sheet里创建第一行，参数为行索引(excel的行)，可以是0～65535之间的任何一个
        HSSFRow row1=sheet.createRow(0);
//创建单元格(excel的单元格，参数为列索引，可以是0～255之间的任何一个
        HSSFCell cell=row1.createCell(0);
        //字段数字
        List fieldDate = new  ArrayList();
        //对应序号
        List fieldDateid = new  ArrayList();
        for (Map<String,String> map : columns){
            fieldDate.add(map.get("title").toLowerCase());
            fieldDateid.add(map.get("tindex").toLowerCase());
//				System.out.println(map.get("title"));
        }
        //拼接 全部数据 表头
          preposition.addAll(fieldDate);
        //拼接表头对应数据
          prepositiondate.addAll(fieldDateid);
        //设置单元格内容
        cell.setCellValue("过称数据报表");
        Short s = 1000;
        row1.setHeight(s);
        cell.setCellStyle(style);
        sheet.addMergedRegion(new CellRangeAddress(0,0,0,prepositiondate.size()));
        //创建表头
        HSSFRow row2=sheet.createRow(1);
          //创建表头全部
        for (int i = 0; i <preposition.size() ; i++) {
            row2.createCell(i).setCellValue(preposition.get(i).toString());
            sheet.setColumnWidth(i,3000);

        }
        //除过表头剩下所有数据 从第一条数据开始遍历
        //从第三行开始
        //遍历数据
        int num =0;
        String colum ="";
        for (Map<String,String> maps : columnsDate){
            //存每一条数据 根据字段获取
            ++ num;
            HSSFRow row=sheet.createRow((1+num));
            for (int k = 0; k <prepositiondate.size(); k++) {
                    //第一条数据 判断不为空
                    sheet.setColumnWidth(0, 3766);
                    //先把前置表头写完 后面写自定义数据
                    if(k<=16){
                        row.createCell(k).setCellValue(maps.get(prepositiondate.get(k)));
                    } else {
                    //字段值
                    colum ="d"+prepositiondate.get(k);
                    row.createCell(k).setCellValue(maps.get(colum));
                }
            }
        }

        OutputStream output=response.getOutputStream();

        response.reset();

        response.setHeader("Content-disposition", "attachment; filename=details.xls");

        response.setContentType("application/msexcel");

        wb.write(output);

        output.close();