ExpressJS -在服务器端生成CSV文件，并允许从客户端下载

npm install express

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

app.get('/generate-csv', (req, res) => {
  // 生成CSV文件的逻辑代码
});

const csvWriter = createCsvWriter({
  path: 'data.csv',
  header: [
    { id: 'name', title: 'Name' },
    { id: 'age', title: 'Age' },
    { id: 'email', title: 'Email' }
  ]
});

const data = [
  { name: 'John Doe', age: 30, email: 'johndoe@example.com' },
  { name: 'Jane Smith', age: 25, email: 'janesmith@example.com' },
  { name: 'Bob Johnson', age: 35, email: 'bobjohnson@example.com' }
];

csvWriter.writeRecords(data)
  .then(() => {
    console.log('CSV file generated');
    // 发送CSV文件给客户端下载
    res.download('data.csv');
  })
  .catch((error) => {
    console.error(error);
    res.status(500).send('Internal Server Error');
  });

app.listen(3000, () => {
  console.log('Server started on port 3000');
});