超实用,vue中使用XLSX解析读取excel文件内容

1,191 阅读1分钟

不说废话,直接上代码

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);
	});
}