JavaScript 以追加的方式写入xlsx

实现功能

通过js将一个一维列表的数据，以追加的方式按行写入指定xlsx中

需要在终端安装以下的包

npm install xlsx

js代码

function write_to_excel(existing_path,newData) {
    const XLSX = require('xlsx');
    const workbook = XLSX.readFile(existing_path);
    const worksheet = workbook.Sheets[workbook.SheetNames[0]];
    const existingData = XLSX.utils.sheet_to_json(worksheet, {header: 1});
    existingData.push(newData);
    const newWorksheet = XLSX.utils.aoa_to_sheet(existingData);
    workbook.Sheets[workbook.SheetNames[0]] = newWorksheet;
    XLSX.writeFile(workbook, existing_path);
}
 
const existing_path = "具体的文件路径"
const newData= ["具体的列表数据1","具体的列表数据2",]
write_to_excel(existing_path,newData)