js导出html表格为xlsx实例

1002710030

已于 2023-08-21 15:25:26 修改

阅读量156

点赞数

文章标签： javascript html 前端

于 2023-08-04 16:07:02 首次发布

本文链接：https://blog.csdn.net/qq_35776207/article/details/132106789

版权

<!DOCTYPE html>
<html>
<head>
	<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
	<title></title>
	<link rel="stylesheet" href="bootstrap.min.css">
	<script src="jquery.min.js"></script>
	<script src="bootstrap.min.js"></script>
	<script src="https://unpkg.com/xlsx/dist/xlsx.full.min.js"></script>
</head>
<input type="submit" name="" value="导出" class="btn btn-primary" onclick="dc()">
<table width="" class="table table-bordered" id="xx">
	<tr>
		<td>1</td>
		<td>2</td>
		<td>3</td>
	</tr>
</table>

<script>
	function dc() {
		var table = document.getElementById("xx");
		var wb = XLSX.utils.table_to_book(table);
		var wbout = XLSX.write(wb, { bookType: 'xlsx', type: 'binary' });
		function s2ab(s) {
			var buf = new ArrayBuffer(s.length);
			var view = new Uint8Array(buf);
			for (var i = 0; i < s.length; i++) {
				view[i] = s.charCodeAt(i) & 0xFF;
			}
			return buf;
		}
		var blob = new Blob([s2ab(wbout)], { type: 'application/octet-stream' });
		var a = document.createElement("a");
		document.body.appendChild(a);
		a.style = "display: none";
		var url = window.URL.createObjectURL(blob);
		a.href = url;
		a.download = "table.xlsx";
		a.click();
		window.URL.revokeObjectURL(url);
	}
</script>