不说废话,直接上代码
yarn add xlsx
import XLSX from 'xlsx';
export function file2Xce (file) {
return new Promise(function (resolve, reject) {
const reader = new FileReader();
reader.onload = function (e) {
const data = e.target.result;
console.log(data);
const workbook = XLSX.read(data, {
type: 'binary'
});
let result = []
workbook.SheetNames.forEach(item => {
result.push({
sheetName: item,
data: XLSX.utils.sheet_to_json(workbook.Sheets[item])
})
})
resolve(result);
};
reader.readAsBinaryString(file);
});
}