js 导出table数据到Excel 解决Excel无网格问题

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

qq_37028972

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

阅读量765

点赞数 1

文章标签： javascript html

本文链接：https://blog.csdn.net/qq_37028972/article/details/124975875

版权

<html>

<head>

<tr>

<th>Header 1</th>

<th>Header 2</th>

</tr>

<tr>

</tr>

<tr>

</tr>

</table>

</head>

<body>

function tableToExcel() {

var tableName = "xx表格导出";

var table = document.getElementById("table").outerHTML;

var exportFileContent = '<html xmlns:x="urn:schemas-microsoft-com:office:excel"><head><xml><x:ExcelWorkbook><x:ExcelWorksheets><x:ExcelWorksheet><x:Name>'+tableName+'</x:Name><x:WorksheetOptions><x:Print><x:ValidPrinterInfo /></x:Print></x:WorksheetOptions></x:ExcelWorksheet></x:ExcelWorksheets></x:ExcelWorkbook></xml></head>'+table +'</html>';

var blob = new Blob([exportFileContent], {type: "text/plain;charset=utf-8"});

blob = new Blob([String.fromCharCode(0xFEFF), blob], {type: blob.type});

var link = window.URL.createObjectURL(blob);

var a = document.createElement("a");

a.download = tableName +".xls";

a.href = link;

document.body.appendChild(a);

a.click();

document.body.removeChild(a);

}

</script>

</body>