<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8" />
<meta name="viewport" content="width=device-width, initial-scale=1">
<title>js导出excel</title>
</head>
<body>
<button type="button" onclick="test()">导出excel</button>
</body>
<script type="text/javascript">
function test(){
var str = "序列号,姓名,班级,总分\n";
var title = "学生成绩表.csv";
var data = [{id:'1',name:'张三',grade:'高一三班',total:'360'}, {id:'2',name:'李四',grade:'高二一班',total:'440'}, {id:'3',name:'王二麻子',grade:'高三二班',total:'550'}];
for(let i = 0 ; i < data.length ; i++ ){
for(var item in data[i]){
str+=`${data[i][item] + '\t'},`;
}
str+='\n';
}
//encodeURIComponent解决中文乱码
let uri = 'data:text/csv;charset=utf-8,\ufeff' + encodeURIComponent(str);
//通过创建a标签实现
let link = document.createElement("a");
link.href = uri;
//对下载的文件命名
link.download = title;
document.body.appendChild(link);
link.click();
document.body.removeChild(link);
}
</script>
</html>
使用js导出excel
最新推荐文章于 2024-08-06 16:10:14 发布