Node.JS學習筆記(9)_CSV檔案讀取寫入

https://replit.com/

寫入模組

npm i -s csv-writer

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

const csvWriter = createCsvWriter({

  path: 'out.csv',

  header: [

    {id: 'name', title: 'Name'},

    {id: 'surname', title: 'Surname'},

    {id: 'age', title: 'Age'},

    {id: 'gender', title: 'Gender'},

  ]

});

const data = [

  {

    name: 'John',

    surname: 'Snow',

    age: 26,

    gender: 'M'

  }, {

    name: 'Clair',

    surname: 'White',

    age: 33,

    gender: 'F',

  }, {

    name: 'Fancy',

    surname: 'Brown',

    age: 78,

    gender: 'F'

  }

];

csvWriter

  .writeRecords(data)

  .then(()=> console.log('The CSV file was written successfully'));

讀取CSV解析模組

npm i -s csv-parser

const csv = require('csv-parser');

const fs = require('fs');

fs.createReadStream('out.csv')

  .pipe(csv())

  .on('data', (row) => {

    console.log(row);

  })

  .on('end', () => {

    console.log('CSV file successfully processed');

  });