node模块之 xlsx 使用

npm i xlsx -S

读取数据

let xlsx = require('xlsx');

let workbook = xlsx.readFile('susu.xlsx'); //workbook就是xls文档对象

let sheetNames = workbook.SheetNames; //获取表明

//  可多sheet  循环
let sheet = workbook.Sheets[sheetNames[0]]; //通过表明得到表对象

var data =xlsx.utils.sheet_to_json(sheet); //通过工具将表对象的数据读出来并转成json

写数据

let xlsx = require('xlsx');
let json = [ 
    {"大标题":null},
    {null:"大标题"},
    {null:"大标题"},
    {null:"大标题"},
    { Name: 'name_01', Age: 21, Address: 'address_01' },
    { Name: 'name_02', Age: 22, Address: 'address_02' },
    { Name: 'name_03', Age: 23, Address: 'address_03' },
    { Name: 'name_04', Age: 24, Address: 'address_04' },
    { Name: 'name_05', Age: 25, Address: 'address_05' }, ];

let ss = xlsx.utils.json_to_sheet(json); //通过工具将