excel表怎样存入mysql数据库

import xlrd
import pymysql

# 打开Excel文件
workbook = xlrd.open_workbook('example.xlsx')
sheet = workbook.sheet_by_index(0)

# 连接到MySQL数据库
connection = pymysql.connect(host='localhost', user='root', password='password', database='your_database')
cursor = connection.cursor()

# 循环遍历Excel表中的数据，并插入到MySQL表中
for i in range(1, sheet.nrows):
    data = (sheet.cell_value(i, 0), sheet.cell_value(i, 1), sheet.cell_value(i, 2))  # 假设Excel表有3列数据
    sql = "INSERT INTO your_table (column1, column2, column3) VALUES (%s, %s, %s)"  # 假设MySQL表有3列数据
    cursor.execute(sql, data)

# 提交事务并关闭连接
connection.commit()
connection.close()