js 根据 json 导出 excel 简单实例

KingFu28

已于 2024-06-06 09:54:54 修改

阅读量276

点赞数

文章标签： javascript json excel

于 2023-09-11 13:40:35 首次发布

本文链接：https://blog.csdn.net/kingwin28/article/details/132804133

版权

注：需要在body内触发

<html>
<head>
<meta charset="utf-8">
<script src="https://cdn.sheetjs.com/xlsx-0.20.2/package/dist/xlsx.full.min.js"></script>
</head>
<script>
function exportExcel(){
	var jsonData = [{
	'aaa':'1111','bbb':'bbbbb1','ccc':'ccccc1'
	},{
	'aaa':'2222','bbb':'bbbbb2','ccc':'工工工工'
	},{
	'aaa':'3333','bbb':'bbbbb3','ccc':'ccccc3'
	}];
	// 换列的 Title，可不用。
	jsonData = jsonData.map(oldItem => {
		let newItem = { ...oldItem }; 
		newItem['Workflow Name'] = oldItem.aaa;
		delete newItem.aaa;
		newItem['Ticket No.'] = oldItem.bbb;
		delete newItem.bbb;
		newItem['Title'] = oldItem.ccc;
		delete newItem.ccc;
		return newItem;
	});

	var worksheet = XLSX.utils.json_to_sheet(jsonData);
	// 列宽
	worksheet['!cols'] = [{wch: 30},{wch: 20},{wch: 40}];
	var workbook = XLSX.utils.book_new();
	
	XLSX.utils.book_append_sheet(workbook, worksheet, "Sheet1");
	XLSX.writeFile(workbook, "Team_" + new Date().toJSON().substr(0,10) + ".xlsx");
}

</script>
<body>
<button type="button" style="text-align: center;margin: 10px;" onclick="exportExcel()" >导出 Excel</button>
</body>
</htmll>