如何以编程方式将excel/CSV数据导入MongoDB集合/文档(MERN)

npm install csv-parser mongodb

const fs = require('fs');
const MongoClient = require('mongodb').MongoClient;
const csv = require('csv-parser');

// MongoDB连接字符串
const url = 'mongodb://localhost:27017';
const dbName = 'myDatabase';
const collectionName = 'myCollection';

// 创建MongoDB客户端
const client = new MongoClient(url, { useUnifiedTopology: true });

// 连接到MongoDB服务器
client.connect((err) => {
  if (err) throw err;
  console.log('Connected to MongoDB server');

  const db = client.db(dbName);
  const collection = db.collection(collectionName);

  // 读取CSV文件并导入MongoDB
  fs.createReadStream('data.csv')
    .pipe(csv())
    .on('data', (row) => {
      // 将CSV行转换为MongoDB文档
      const document = {};
      for (const key in row) {
        document[key] = row[key];
      }
      collection.insertOne(document, (err, res) => {
        if (err) throw err;
        console.log('Inserted document:', res);
      });
    })
    .on('end', () => {
      console.log('CSV file successfully processed');
      client.close();
    });
});