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)); //将数据写入文件