npm地址:https://www.npmjs.com/package/js-xlsx
实现的功能
excel转json
XLSX.utils.sheet_to_json(worksheet)
if(typeof require !== 'undefined') XLSX = require('xlsx');
const path = require('path')
const xlsPath = path.join(__dirname, './assets/2020-10-15.xls')
var workbook = XLSX.readFile(xlsPath);
var sheet_name_list = workbook.SheetNames;
sheet_name_list.forEach(function(y) { /* iterate through sheets */
// console.log(y) // Sheet1
var worksheet = workbook.Sheets[y];
// const jsonData = JSON.stringify( XLSX.utils.sheet_to_json(worksheet) ); // 得到json字符串
const jsonData = XLSX.utils.sheet_to_json(worksheet); // 得到json数组
// console.log(jsonData);
}