一、下载js文件
SheetJS：https://github.com/SheetJS/sheetjs/tree/master/dist
下载xlsx.full.min.js.jpg
二、代码
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>纯js读取excel文件内容并显示</title>
<script src="./js/xlsx.full.min.js"></script>
</head>
<body>
<input type="file" onchange="readExcel(this)">
</body>
<script>
function readExcel(fileObj){
var reader = new FileReader();
var file = fileObj.files[0];
reader.readAsArrayBuffer(file);
reader.onload = function(e){
var data = e.target.result;
var wb = window.XLSX.read(data,{type:'binary'});
sheetName = wb.SheetNames[0]
sheets = wb.Sheets[sheetName]
console.log(sheets)
//转换为json格式
console.log(JSON.stringify(XLSX.utils.sheet_to_json(sheets)))
}
}
</script>
</html>
三、读取结果
excel档案.jpg
读取结果.jpg
