如何将数据库中的数据导出到Excel？Nodejs

const mysql = require('mysql');
const ExcelJS = require('exceljs');

// 创建数据库连接
const connection = mysql.createConnection({
  host: 'localhost',
  user: 'root',
  password: 'password',
  database: 'mydatabase'
});

// 连接数据库
connection.connect();

// 查询数据
connection.query('SELECT * FROM mytable', (error, results) => {
  if (error) throw error;

  // 创建Excel工作簿
  const workbook = new ExcelJS.Workbook();
  const worksheet = workbook.addWorksheet('Sheet 1');

  // 添加表头
  const headers = Object.keys(results[0]);
  worksheet.addRow(headers);

  // 添加数据行
  results.forEach(row => {
    const values = Object.values(row);
    worksheet.addRow(values);
  });

  // 导出Excel文件
  workbook.xlsx.writeFile('data.xlsx')
    .then(() => {
      console.log('数据导出成功！');
    })
    .catch(error => {
      console.log('数据导出失败：', error);
    })
    .finally(() => {
      // 关闭数据库连接
      connection.end();
    });
});