js生成xlsx/xls文件并下载到本地
/*************************************************************************************/
//导出excel相关函数
function sheet2blob(sheet, sheetName) {//将文件转换为二进制文件
sheetName = sheetName || 'sheet1';
var workbook = {
SheetNames: [sheetName],
Sheets: {}
};
workbook.Sheets[sheetName] = sheet;
// 生成excel的配置项
var wopts = {
bookType: 'xlsx', // 要生成的文件类型
bookSST: false, // 是否生成Shared String Table，官方解释是，如果开启生成速度会下降，但在低版本IOS设备上有更好的兼容性
type: 'binary'
};
var wbout = XLSX.write(workbook, wopts);
var blob = new Blob([s2ab(wbout)], {type:"application/octet-stream"});
// 字符串转ArrayBuffer
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;
}
return blob;
}
/*************************************************************************************/
function openDownloadXLSXDialog(url, saveName){//下载模板文件
if(typeof url == 'object' && url instanceof Blob){
url = URL.createObjectURL(url); // 创建blob地址
}
var aLink = document.createElement('a');
aLink.href = url;
aLink.download = saveName || ''; // HTML5新增的属性，指定保存文件名，可以不要后缀，注意，file:///模式下不会生效
var event;
if(window.MouseEvent) event = new MouseEvent('click');
else{
event = document.createEvent('MouseEvents');
event.initMouseEvent('click', true, false, window, 0, 0, 0, 0, 0, false, false, false, false, 0, null);
}
aLink.dispatchEvent(event);
}
/*************************************************************************************/
function teaModel(){//下载监考老师xlsx文件模板
var array = [['监考号','姓名','手机号','考场','考场号','签到','openid']];
var sheet = XLSX.utils.aoa_to_sheet(array);
var blob = sheet2blob(sheet, '监考老师');
openDownloadXLSXDialog(blob, 'xxxxx-监考老师.xlsx');
}
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title style="margin-left: 800px;">考试 管 理 系 统</title>
<script type="text/javascript" src="./js/xlsx.mini.js"></script>
</head>
<body>
<input id="btn" type="button" onclick="teaModel()" disabled value="下载文件"/>
</body>
</html>
运行结果截图:
版权声明：本文为weixin_42708896原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。