node 把一个 xlsx 文件导入到 mongodb数据库

装必要的依赖项：您需要安装 xlsx 和 mongodb 包来读取和写入数据。

npm install xlsx mongodb --save

编写 node 执行的代码

const xlsx = require('xlsx');
const MongoClient = require('mongodb').MongoClient;

// 读取Excel文件并提取数据
const workbook = xlsx.readFile('2011.xlsx');
const sheet = workbook.Sheets['Sheet1'];
const students = xlsx.utils.sheet_to_json(sheet);

const client = new MongoClient('mongodb://localhost:27017', { monitorCommands: true });

client.on('commandStarted', started => console.log(started));
client.db('class').collection('student').insertMany(students).then(r => {
    console.log(r);
    client.close();
});