如何用node.js将excel文件导入MySQL？

npm install mysql xlsx

const mysql = require('mysql');
const xlsx = require('xlsx');

const connection = mysql.createConnection({
  host: 'localhost',
  user: 'root',
  password: 'password',
  database: 'database_name'
});

connection.connect();

const workbook = xlsx.readFile('path/to/excel_file.xlsx');
const worksheet = workbook.Sheets[workbook.SheetNames[0]];
const data = xlsx.utils.sheet_to_json(worksheet, { header: 1 });

for (let i = 1; i < data.length; i++) {
  const row = data[i];
  const sql = `INSERT INTO table_name (column1, column2, ...) VALUES (?, ?, ...)`;
  connection.query(sql, row, (error, results, fields) => {
    if (error) throw error;
    console.log(`Inserted row ${i}`);
  });
}

connection.end();