java实现前后端交互导出excel

第一步、前端获取参数并且通过form表单或者URL方式访问后台

//定义params对象接收键值对参数 var params = {
    isChecked: 1,
    startTime: "2017-03-05",
    endTime: "2017-03-08",
    status: 1,
    arbType: 2423,
    claimsStatus: 3412,
    arbDutyId: 542,
    siteId: 54,
    provinceId: 1342
};//把param对象拼接成字符串 var encodeParam = function(json) {
    var tmps = [];
    for ( var key in json) {
        tmps.push(key + = + json[key]);
    }
    return tmps.join(&);
}//定义url var url=basePath+"submenuController/export?"+encodeParam(query);
//判断是否有id为_exportForm的form表单，如果没有则创建一个隐藏的form，把url放入，然后submit
var exportForm = document.getElementById("_exportForm");
if (!exportForm){
    exportForm = document.createElement("form");
    exportForm.setAttribute(id,"_exportForm");
    exportForm.setAttribute("action", url);
    exportForm.setAttribute("method", "post");
}
document.body.appendChild(exportForm);
exportForm.submit();

@RequestMapping(value ="export",method = RequestMethod.POST)
@ResponseBody
public void exportSiteDeclareList(HttpServletResponse response,SubmenuQuery query){
    String[] headArray = {
         
  "运单号","理赔情况","申报网点名称","省区","申报类型","责任类型",
            "仲裁登记时间","寄件日期","仲裁审核日期","分单人","分单时间"};
    List<SubmenuVO> list = this.submenuFacade.findSubmenuPageQuery(query).getRows();
    List<Object[]> contentList = new ArrayList<>();
    if(list.size()>0) {
        for (SubmenuVO entity : list) {
            Object[] o = {
                    entity.getEwbNo(),//"运单号
                    entity.getClaimsStatus(),//理赔情况
                    entity.getDeclareSiteName(),//申报网点名称
                    entity.getProvinceAreaName(),//省区
                    entity.getArbTypeName(),//申报类型
                    entity.getArbDutyName(),//责任类型
                    entity.getArbRegisterTime(),//仲裁登记时间
                    entity.getEwbDate(),//寄件日期
                    entity.getArbCheckTime(),//仲裁审核日期
                    entity.getUserName(),//分单人
                    entity.getCreateTime()//分单时间
            };

            contentList.add(o);
        }
    }else{
        return;
    }
    try {
         ExeclUtil.ExportExcel(response, headArray, contentList, "SubmenuList.xls");
    } catch (Exception e) {
        LOGGER.error("网点理赔申报导出报错"+e);
    }
}

第三步、Excel工具类