下载插件
npm i xlsjs
示例
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<title></title>
</head>
<script src="./js_xlsx.core.min.js" type="text/javascript" charset="utf-8"></script>
<script src="./jquery.min.js" type="text/javascript" charset="utf-8"></script>
<body>
<input type="file" id="file" />
</body>
</html>
<script type="text/javascript">
$(function() {
document.getElementById('file').addEventListener('change', function(e) {
var files = e.target.files;
if (files.length == 0) return;
var f = files[0];
if (!/\.xlsx$/g.test(f.name)) {
alert('仅支持读取xlsx格式!');
return;
}
readWorkbookFromLocalFile(f, function(workbook) {
readWorkbook(workbook);
});
});
});
function readWorkbook(workbook) {
var sheetNames = workbook.SheetNames;
var worksheet = workbook.Sheets[sheetNames[0]];
var csv = XLSX.utils.sheet_to_csv(worksheet);
let stringResult = csv.replace(/(\r\n)|(\n)/g, ',');
let stringResult2 = stringResult.split(',');
console.log(stringResult2);
return
}
function readWorkbookFromLocalFile(file, callback) {
var reader = new FileReader();
reader.onload = function(e) {
var data = e.target.result;
var workbook = XLSX.read(data, {
type: 'binary'
});
if (callback) callback(workbook);
};
reader.readAsBinaryString(file);
}
</script>