poi 导出Excel java代码

js:

function initBatchExport(url,sub_key,current_sub_num){
    var btn_id="#btn_char"+current_sub_num;
    if(Number(current_sub_num)==1){
        btn_id="#btn_char";
    }
//    查询条件
    //var paramObj=new Object();
    //var result_Data ={};
    month_value=$("#month_value").val();
    dim_key = sub_key;
    type = "量";
    var exportUrl=basePath+'/amount/initBatchExport.do?month_value='+month_value+'&dim_key='+dim_key+'&type='+type+'&current_sub_num='+current_sub_num;
    for (var i = 1; i <=Number(current_sub_num); i++) {
        var parent_key = "parent_dim_"+(i);
        exportUrl+='&'+parent_key+'='+$("#"+parent_key).val();
    }
    $(btn_id).on("click",function(){
        
    //    var excelurl ="<%=basePath%>/hfx/unwantExport.action?impId="+impId;
        
        location.href=exportUrl;
    });
}

controller:

@RequestMapping(value = "/initBatchExport", method = {RequestMethod.GET,RequestMethod.POST})
    @ResponseBody
    public void initBatchExport(Locale locale, Model model,HttpServletRequest request,HttpServletResponse response){
        ResultMap data =ResultMap.defaultResultMap(); //new HashMap<String,Object>();
        //Map<String,String>  param = RequestUtils.getParamsMap(request);
        Map<String,String>  param =new HashMap<String,String>();
        Map map = request.getParameterMap();
        String current_sub_num = request.getParameter("current_sub_num");
        String month_value = request.getParameter("month_value");
        String dim_key = request.getParameter("dim_key");
        String type = request.getParameter("type");
        for (int i = 1; i <=Integer.parseInt(current_sub_num); i++) {
            String parent_key = "parent_dim_"+(i);
            param.put(parent_key, request.getParameter(parent_key));
        }
        param.put("current_sub_num", current_sub_num);
        param.put("month_value", month_value);
        param.put("dim_key", dim_key);
        param.put("type", type);
        //需导出的数据
        List<ZdResult8BrandD> list = amonutService.initJqGrid(param);
        //初始化导出Excel
        // 第一步，创建一个webbook，对应一个Excel文件 
          HSSFWorkbook wb = new HSSFWorkbook(); 
          // 第二步，在webbook中添加一个sheet,对应Excel文件中的sheet 
          HSSFSheet sheet = wb.createSheet("Sheet1"); 
          // 第三步，在sheet中添加表头第0行,注意老版本poi对Excel的行数列数有限制short 
          HSSFRow row = sheet.createRow(0); 
          // 第四步，创建单元格，并设置值表头 设置表头居中 
          HSSFCellStyle style = wb.createCellStyle(); 
          style.setAlignment(HSSFCellStyle.ALIGN_CENTER); // 创建一个居中格式 

          HSSFCell cell = row.createCell(0);
          //'账期', '地市', '品牌','机型', '价格段', '客户','分类客户', 'subtype','value'
          cell.setCellValue("账期"); 
          cell.setCellStyle(style); 
          cell = row.createCell(1); 
          cell.setCellValue("地市"); 
          cell.setCellStyle(style); 
          cell = row.createCell(2); 
          cell.setCellValue("品牌"); 
          cell.setCellStyle(style); 
          cell = row.createCell(3); 
          cell.setCellValue("机型"); 
          cell.setCellStyle(style);
          cell = row.createCell(4); 
          cell.setCellValue("价格段"); 
          cell.setCellStyle(style);
          cell = row.createCell(5); 
          cell.setCellValue("客户"); 
          cell.setCellStyle(style);
          cell = row.createCell(6); 
          cell.setCellValue("分类客户"); 
          cell.setCellStyle(style);
          cell = row.createCell(7); 
          cell.setCellValue("子类"); 
          cell.setCellStyle(style);
          cell = row.createCell(8); 
          cell.setCellValue("值"); 
          cell.setCellStyle(style);

          // 第五步，写入实体数据
          for (int i = 0; i < list.size(); i++){ 
               row = sheet.createRow(i + 1); 
               ZdResult8BrandD zdResult = list.get(i); 
               // 第四步，创建单元格，并设置值 
               row.createCell(0).setCellValue(zdResult.getStatDay()); 
               row.createCell(1).setCellValue(zdResult.getAreaName()); 
               row.createCell(2).setCellValue(zdResult.getBrandName()); 
               row.createCell(3).setCellValue(zdResult.getSpec()); 
               row.createCell(4).setCellValue(zdResult.getPriceRange()); 
               row.createCell(5).setCellValue(zdResult.getCustName()); 
               row.createCell(6).setCellValue(zdResult.getCustStage()); 
               row.createCell(7).setCellValue(zdResult.getSubType()); 
               row.createCell(8).setCellValue(zdResult.getValue()); 
//               cell = row.createCell(3); 
//               cell.setCellValue(new SimpleDateFormat("yyyy-MM-dd").format(stu.getTime())); 
              }

        //第六步,输出Excel文件
          try {
          OutputStream output=response.getOutputStream();
          response.reset();
          SimpleDateFormat df = new SimpleDateFormat("yyyy_MM_dd HHmmss");//设置日期格式
          String fileName = dim_key+df.format(new Date());// new Date()为获取当前系统时间
          response.setHeader("Content-disposition", "attachment; filename="+fileName+".xls");
          response.setContentType("application/msexcel");  
        
            wb.write(output);
            output.flush();
        } catch (IOException e) {
            e.printStackTrace();
        }
          

        //return resultMap;
    }