nodejs的xlsx库操作xlsx文件的基本操作

const XLSX = require('xlsx');
const fs = require('fs');
const path = require('path')
const workbook = XLSX.readFile(path.join(__dirname, './name.xlsx'));
// 获取 Excel 中所有表名
const sheetNames = workbook.SheetNames; // 返回 ['sheet1', 'sheet2']
// 根据表名获取对应某张表
const sheet1 = workbook.Sheets[sheetNames[0]];
const sheet2 = workbook.Sheets[sheetNames[2]];

let sheet1_json = XLSX.utils.sheet_to_json(sheet1);
let sheet2_json = XLSX.utils.sheet_to_json(sheet2);

let ss = XLSX.utils.json_to_sheet(sheet1_json); //通过工具将json转表对象
let ss1 = XLSX.utils.json_to_sheet(sheet2_json); //通过工具将json转表对象

let workbook_write = { //定义操作文档
    SheetNames: ['nodejs-sheetname', 'nodejs-sheetname1'], //定义表名
    Sheets: {
        'nodejs-sheetname': Object.assign({}, ss, {
            '!ref': ss['!ref']
        }), //表对象[注意表明]
        'nodejs-sheetname1': Object.assign({}, ss1, {
            '!ref': ss1['!ref']
        }) //表对象[注意表明]
    },
}
XLSX.writeFile(workbook_write, path.join(__dirname, target_path)); //将数据写入文件