js 导出excel

function autoDaochu() { ???????var url = ‘r/mb1/syxExpToExcel.htm‘; ???????var data = { ???????????name: ‘1‘, ???????????sex: ‘男‘ ???????} ???????var formId = ‘a‘ + new Date().valueOf(); ???????var html = ‘<form id="‘ + formId + ‘" action="‘ + url + ‘" method="post" style="display:none">‘; ???????for (var i in data) { ???????????html += ‘<input name="‘ + i + ‘" type="text" value="‘ + data[i] + ‘"/>‘; ???????} ???????html += ‘</form>‘; ???????$(‘body‘).append(html); ???????$("#"+formId)[0].submit(); ???}

@RequestMapping(value = "/syxExpToExcel", method = RequestMethod.POST) ???public void expToExcel(HttpServletRequest request, HttpServletResponse response)throws Exception { ???????PrintWriter pw=response.getWriter(); ???????try{ ???????????response.setContentType("application/x-msdownload;charset=gbk"); ???????????response.setCharacterEncoding("UTF-8"); ???????????String fileName = ?"11" + ".xls"; ???????????String fileNameTemp = URLEncoder.encode(fileName, "UTF-8"); ???????????response.setHeader("Content-Disposition", "attachment; filename=" ???????????????????+ new String(fileNameTemp.getBytes("utf-8"), "gbk")); ???????????OutputStream os = response.getOutputStream(); ???????????//ExcelUtils eu = new ExcelUtils(); ???????????//eu.export(os, "", ?legends ,colLength, DbUtils.ListMapToListObject(result),0,0); ???????????os.flush(); ???????????os.close(); ???????}catch(Exception e){ ???????????e.printStackTrace(); ???????????pw.print("fail"); ???????} ???}