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();
    }

或者

 //导出excel
        $('#exportBtn').on('click', function () {
            var dataParams = {
                export_excel: 1,
                pathname: $('#pathname').val(),
                date1: $('#date1').val(),
                date2: $('#date2').val()
            };
            var params = $.param(dataParams);
            var url = '/r/statistics/1002?t=' + new Date().valueOf() + "&" + params;
            $('<form method="post" action="' + url + '"></form>').appendTo('body').submit().remove();
        });

 

 

 

java 代码

@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");
        }
    }