引入xlsx.core.min.js文件,可以去官网下载
<div class="col-md-4">
<button class="btn btn-default" style="width: 90px;" id="Uploadbtn" disabled="disabled" type="button"><i class="glyphicon glyphicon-upload"></i>Upload</button>
<a class=" btn btn-primary iron-lang" title="Please select a file">
<input class="btnFileUpload" id="UploadData" type="file" accept=".xlsx" style="position: absolute; height: 100%; width: 120px; margin: -6px 0 0 -27px; opacity: 0; cursor: pointer;" />
<i class="fa fa-folder-open"></i><span class="hidden-xs">Browse...</span> </a>
</div>
$("#UploadData").on('change', function (event) {
//清空预留数据
MaintenanceScheduledata = null;
var obj = $(this)[0];
if (obj.files.length == 0) {
return;
}
const IMPORTFILE_MAXSIZE = 10 * 1024;//这里可以自定义控制导入文件大小
var suffix = obj.files[0].name.split(".")[1];
$('input[name="textfile"]').val(obj.files[0].name);
if (suffix != 'xlsx') {
layer.msg("Only support xlsx!");
return;
}
if (obj.files[0].size / 1024 > IMPORTFILE_MAXSIZE) {
layer.msg("The file can not over 10MB");
return;
}
var f = obj.files[0];
var reader = new FileReader();
var rABS = false;
reader.onload = function (e) {
data = e.target.result;
if (rABS) {
wb = XLSX.read(btoa(fixdata(data)), {//手动转化
type: 'base64'
});
} else {
wb = XLSX.read(data, {
type: 'binary'
});
}
//wb.SheetNames[0]是获取Sheets中第一个Sheet的名字
//wb.Sheets[Sheet名]获取第一个Sheet的数据
for (var i = 0; i < wb.SheetNames.length; i++) {
data = XLSX.utils.sheet_to_json(wb.Sheets[wb.SheetNames[i]], { range: 1, header: 1, defval: '' });
if (wb.SheetNames[i] == "MaintenanceSchedule") {
MaintenanceScheduledata = XLSX.utils.sheet_to_json(wb.Sheets[wb.SheetNames[i]], { range: 1, header: 1, defval: '' });//解析数据
MaintenanceScheduleExcelHead = XLSX.utils.sheet_to_json(wb.Sheets[wb.SheetNames[i]], { raw: true, header: 1 })[0];
}
}
if (MaintenanceScheduledata.length == 0) {
layer.msg("The file is empty or file data mismatch ,please choose another file!");
$("#Uploadbtn").attr("disabled", true);
return false;
}
};
//开始读取上传的xlsx数据
if (rABS) {
reader.readAsArrayBuffer(f);
} else {
reader.readAsBinaryString(f);
}
//显示上传表含有的table
$("#ImportTablesName").show();
//上传按钮设置为可用
$("#Uploadbtn").attr("disabled", false);
})