将列添加到csv文件javascript:nodejs

npm install csv-parser csv-writer

const fs = require('fs');
const csv = require('csv-parser');
const createCsvWriter = require('csv-writer').createObjectCsvWriter;

// 读取原始CSV文件
const results = [];
fs.createReadStream('input.csv')
  .pipe(csv())
  .on('data', (data) => results.push(data))
  .on('end', () => {
    // 添加新的列
    results.forEach((row) => {
      row.newColumn = 'new value';
    });

    // 写入新的CSV文件
    const csvWriter = createCsvWriter({
      path: 'output.csv',
      header: Object.keys(results[0]).map((key) => ({ id: key, title: key })),
    });
    csvWriter.writeRecords(results)
      .then(() => console.log('CSV文件已更新'))
      .catch((error) => console.error(error));
  });