怎么将excel导入mysql数据库

import pandas as pd
import mysql.connector

# 连接到MySQL数据库
mydb = mysql.connector.connect(
  host="localhost",
  user="yourusername",
  password="yourpassword",
  database="yourdatabase"
)

# 读取Excel文件数据
df = pd.read_excel('path_to_excel_file.xlsx')

# 将数据导入MySQL数据库
cursor = mydb.cursor()
for index, row in df.iterrows():
    sql = "INSERT INTO yourtable (column1, column2, ...) VALUES (%s, %s, ...)"
    values = (row['column1'], row['column2'], ...)
    cursor.execute(sql, values)
    mydb.commit()

# 关闭数据库连接
cursor.close()
mydb.close()