首先还是要先引入XLSX,然后通过以下操作可以获得表头
import XLSX from "xlsx";
var excelFile;
var reader = new FileReader();
reader.readAsBinaryString(file);
reader.onload = function(e) {
var data = e.target.result;
excelFile = XLSX.read(data, {
type: "binary"
});
var headers_key = new Array();
var headers = new Array();
var str = XLSX.utils.sheet_to_json(
excelFile.Sheets[excelFile.SheetNames[0]]
);
//str后面的数字代表表头是从第几行开始的,自己根据情况修改
for (var key in str[2]) {
headers_key.push(key); //获取表头key
}
for (var i = 0; i < headers_key.length; i++) {
headers.push(str[2][headers_key[i]]); //获取表头
}
最后headers就是表头