<!DOCTYPE html>
<html>
<head>
<title>导出</title>
<meta charset="utf-8">
</head>
<body>
</body>
<script type="text/javascript" src="js/xlsx.full.min.js"></script>
<script type="text/javascript">
/* 需要导出的JSON数据 */
var data = [
{"姓名":"张三", "城市": "Seattle","age":"12"},
{"姓名":"Mike", "城市": "Los Angeles","age":"22"},
{"姓名":"Zach", "城市": "New York","age":"33"}
];/* 如果没有导入xlsx组件则导入 */
var ws = XLSX.utils.json_to_sheet(data);/* 新建空workbook,然后加入worksheet */
var wb = XLSX.utils.book_new();/*新建book*/
XLSX.utils.book_append_sheet(wb, ws, "People");/* 生成xlsx文件(book,sheet数据,sheet命名) */
XLSX.writeFile(wb, "sheetjs.xlsx");/*写文件(book,xlsx文件名称)*/
</script>
</html>
纯前端 xlsx.js 导出
最新推荐文章于 2024-06-19 16:00:37 发布