js 导出excel

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

5月初

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

阅读量393

点赞数

分类专栏： js 文章标签： javascript excel 开发语言

本文链接：https://blog.csdn.net/zzh738579138/article/details/127548134

版权

js 专栏收录该内容

22 篇文章 0 订阅

订阅专栏

导出.xlsx 格式

//table 是innerHTML
//fileName 要保存的文件名称
export const  exportExcelXlsx = (table,fileName) => {
     // var excelContent = document.querySelector(tableID).innerHTML;
    function base64(content) {
        return window.btoa(unescape(encodeURIComponent(content)));
    }
    // <style type='text/css'>th,td {text-align: center;mso-number-format:\@;vnd.ms-excel.numberformat:\@;}</style>
    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>${fileName}</x:Name><x:WorksheetOptions><x:DisplayGridlines/></x:WorksheetOptions></x:ExcelWorksheet></x:ExcelWorksheets></x:ExcelWorkbook></xml><![endif]--><style type='text/css'>th,td {text-align: center;}</style></head>";
    excelFile += "<body><table style='display:inline-block' width='10%'  border='1'>`;
    excelFile += table.innerHTML;
    excelFile +="</table></body>";
    excelFile += "</html>";
    var link = "data:application/vnd.ms-excel;base64," + base64(excelFile);
    var a = document.createElement("a");
    a.download = fileName + ".xlsx";
    a.href = link;
    a.click();
}