环境准备
yarn init --yes
yarn add xlsx
package.json如下
{
"name": "node-xlsx",
"version": "1.0.0",
"main": "index.js",
"license": "MIT",
"dependencies": {
"xlsx": "^0.16.8"
}
}
index.js
const xl = require('xlsx');
const workbook = xl.readFile('test.xlsx');
const sheetNames = workbook.SheetNames; // 返回 ['sheet1', 'sheet2']
const worksheet = workbook.Sheets[sheetNames[0]];
const data = xl.utils.sheet_to_json(worksheet);
console.log(data);
test.xlsx
image.png
node index.js 结果如下
[ { ID: 1, Name: 'foo' } ]
网友评论