psycopg2插入到postgres -基于excel的数据格式化为数字

import psycopg2
import xlrd

# 连接到PostgreSQL数据库
conn = psycopg2.connect(database="your_database", user="your_username", password="your_password", host="your_host", port="your_port")
cur = conn.cursor()

# 读取Excel文件
workbook = xlrd.open_workbook('your_excel_file.xlsx')
sheet = workbook.sheet_by_index(0)

# 遍历Excel中的数据行
for row in range(1, sheet.nrows):
    # 获取每列数据
    column1 = sheet.cell_value(row, 0)
    column2 = sheet.cell_value(row, 1)
    # 格式化为数字
    column2 = float(column2)

    # 插入数据到PostgreSQL数据库
    cur.execute("INSERT INTO your_table (column1, column2) VALUES (%s, %s)", (column1, column2))

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