MVC 将视图页table导出成excel

<table class="tablelist" id="myTable">
    <thead>
        <tr>
            <th colspan="1" rowspan="3">进出口标志</th>
            <th colspan="3" rowspan="1">纠错项数</th>
            <th colspan="10" rowspan="1">退补税额</th>
        </tr>
        <tr>
            <th colspan="1" rowspan="2">涉及补税</th>
            <th colspan="1" rowspan="2">涉及退税</th>
            <th colspan="1" rowspan="2">无退补税</th>
            <th colspan="5" rowspan="1">补税</th>
            <th colspan="5" rowspan="1">退税</th>
        </tr>
        <tr>
            <th colspan="1" rowspan="1">关税</th>
            <th colspan="1" rowspan="1">增值税</th>
            <th colspan="1" rowspan="1">消费税</th>
            <th colspan="1" rowspan="1">反倾销税</th>
            <th colspan="1" rowspan="1">协定关税</th>

            <th colspan="1" rowspan="1">关税</th>
            <th colspan="1" rowspan="1">增值税</th>
            <th colspan="1" rowspan="1">消费税</th>
            <th colspan="1" rowspan="1">反倾销税</th>
            <th colspan="1" rowspan="1">协定关税</th>
        </tr>
    </thead>
    <tbody>
        @foreach (var item in Model)
        {
            <tr>
                <td style="text-align:center;">@item.I_E_Flag</td>
                <td>
                    @item.involSup
                </td>
                <td>
                    @item.involRef
                </td>
                <td>
                    @item.NoRefSup
                </td>
                <td>
                    @item.customsTariff_Sup
                </td>
                <td>
                    @item.addedValueTax_Sup
                </td>
                <td>
                    @item.ConsumptTax_Sup
                </td>
                <td>
                    @item.antiDumpingTax_Sup
                </td>
                <td>
                    @item.agreementTariff_Sup
                </td>
                <td>
                    @item.customsTariff_Ref
                </td>
                <td>
                    @item.addedValueTax_Ref
                </td>
                <td>
                    @item.ConsumptTax_Ref
                </td>
                <td>
                    @item.antiDumpingTax_Ref
                </td>
                <td>
                    @item.agreementTariff_Ref
                </td>
            </tr>
        }
    </tbody>
</table>
<script type="text/javascript">
    $(‘.tablelist tbody tr:odd‘).addClass(‘odd‘);
    AjaxStop();
</script>

 
@using (Html.BeginForm("ExportExcel", "ClassifyCorrectionRefSupTaxStatistial", new { name = "exportData", id = "exportData" }))
                            {
                                <li>@Html.Hidden("hHtml")</li>
                                <li id="DownLoad"><label>&nbsp;</label><input name="btnsearch" id="btnDownload" type="submit" class="scbtn" onclick="exportExcel()" value="下载" /></li>}

<script >
 function exportExcel() {
         var html = document.getElementById("myTable").outerHTML;
         var shtml = htmlEncode(html);
         $("#output").val(shtml);

         $("input[name=‘hHtml‘]").val(shtml);
         //表单提交
         $("#exportData").submit();
     }
           function htmlEncode(value) {
               //create a in-memory div, set it‘s inner text(which jQuery automatically encodes)
               //then grab the encoded contents back out.  The div never exists on the page.
               return $(‘<div/>‘).text(value).html();
           }
        </script>

 /// <summary>
        /// 下载统计表数据
        /// </summary>
        /// <param name="form"></param>
        /// <returns></returns>
        [HttpPost]
        public FileResult ExportExcel(FormCollection form)
        {
            //第一种:使用FileContentResult
            string content = Request.Form["hHtml"];
            string strHtml = form["hHtml"];
            strHtml = HttpUtility.HtmlDecode(strHtml);//Html解码
            byte[] fileContents = Encoding.UTF8.GetBytes(strHtml);
            string filename = DateTime.Now.ToString("yyyyMMddHHmmss");
            return File(fileContents, "application/ms-excel", "进出口退补税额统计表" + filename + ".xls");

            //第二种:使用FileStreamResult
            var fileStream = new MemoryStream(fileContents);
            return File(fileStream, "application/ms-excel", "fileStream.xls");

            //第三种:使用FilePathResult
            //服务器上首先必须要有这个Excel文件,然会通过Server.MapPath获取路径返回.
            var fileName = Server.MapPath("~/uploads/选题信息导入模板.xls");
            return File(fileName, "application/ms-excel", "fileName.xls");

        }