JS代码：

 

/** * table数据导出到excel * 形参 table  : tableId ; *      sheetName : 工作薄名 *      fileName  : 文件名 *      linkId    ：隐藏的链接控件id */var tableToExcel = (function () {    var uri = 'data:application/vnd.ms-excel;base64,',        template =            '' +                '
     
     
      {table}
',        base64 = function (s) {            return window.btoa(unescape(encodeURIComponent(s)));        },        format = function (s, c) {            return s.replace(/{(\w+)}/g, function (m, p) { return c[p]; });        }    return function (table, sheetName, fileName,linkId) {        if (!table.nodeType)            table = document.getElementById(table);        var ctx = { worksheet: sheetName || 'Worksheet', table: table.innerHTML }        var dlinkInfo = document.getElementById(linkId);        dlinkInfo.href = uri + base64(format(template, ctx));        dlinkInfo.download = fileName;        dlinkInfo.click();    }})();

使用样例：

html部分代码

     
                
      ×                
      
                    
       
                        
        
                            
         
                        
        
                        
        
                            
         
                        
        
                        
        
                            
                                     
                                 
        
                    
       
                
      
            
     
            
     
                
                  
     

JS代码

var exeExportDataToExcel = function () {    var sheetName = $("#tipMessageLabel").html();    var fileName = $("#myModalLabel").html() + ".xls";    tableToExcel("relatedBaseInfoTable", sheetName, fileName, "dlink");}