js导出表格

最新推荐文章于 2024-08-19 11:16:23 发布

zhangjialouzhu

最新推荐文章于 2024-08-19 11:16:23 发布

阅读量88

点赞数 1

分类专栏：笔记文章标签： javascript

本文链接：https://blog.csdn.net/zhangjialouzhu/article/details/115912607

版权

笔记专栏收录该内容

2 篇文章 0 订阅

订阅专栏

function base64 (content) {
   return window.btoa(unescape(encodeURIComponent(content)));         
}
/*
*@tableId: table的Id
*@fileName: 要生成excel文件的名字（不包括后缀，可随意填写）
*/
function tableToExcel(tableID,fileName){
    var table = document.getElementById(tableID);
  var excelContent = table.innerHTML;
  var excelFile = "<html xmlns:o='urn:schemas-microsoft-com:office:office' xmlns:x='urn:schemas-microsoft-com:office:excel' xmlns='http://www.w3.org/TR/REC-html40'>";
  excelFile += "<head><!--[if gte mso 9]><xml><x:ExcelWorkbook><x:ExcelWorksheets><x:ExcelWorksheet><x:Name>{worksheet}</x:Name><x:WorksheetOptions><x:DisplayGridlines/></x:WorksheetOptions></x:ExcelWorksheet></x:ExcelWorksheets></x:ExcelWorkbook></xml><![endif]--></head>";
  excelFile += "<body><table>";
  excelFile += excelContent;
  excelFile += "</table></body>";
  excelFile += "</html>";
  var link = "data:application/vnd.ms-excel;base64," + base64(excelFile);
  var a = document.createElement("a");
  a.download = fileName+".xls";
  a.href = link;
  a.click();
}

导出