如何从xlsx导入列>创建Json数组>更新SQLite DB

import openpyxl
import json
import sqlite3

# 从xlsx文件中导入列数据
def import_columns_from_xlsx(file_path, sheet_name, column_name):
    wb = openpyxl.load_workbook(file_path)
    sheet = wb[sheet_name]
    column_data = [cell.value for cell in sheet[column_name]]
    return column_data

# 创建Json数组
def create_json_array(column_data):
    json_array = json.dumps(column_data)
    return json_array

# 更新SQLite数据库
def update_sqlite_db(json_array, db_path, table_name):
    conn = sqlite3.connect(db_path)
    cursor = conn.cursor()
    cursor.execute(f"UPDATE {table_name} SET column_data = ?", (json_array,))
    conn.commit()
    conn.close()

# 示例用法
file_path = "data.xlsx"
sheet_name = "Sheet1"
column_name = "A"
db_path = "data.db"
table_name = "data_table"

column_data = import_columns_from_xlsx(file_path, sheet_name, column_name)
json_array = create_json_array(column_data)
update_sqlite_db(json_array, db_path, table_name)