node读取xlsx

环境准备

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' } ]