Python 读取Excel中的数据插入到数据库中

import xlrd
import os


# 读取Excel中的数据
def read_excel_data():
    excel_path = os.path.join(os.getcwd(), 'total.xlsx')
    print("~~~~~~~~~~~~>>>Excel文件路径是:" + excel_path)
    excel_file = xlrd.open_workbook(excel_path)
    table = excel_file.sheets()[0]
    print("~~~~~~~~~~~~>>>已经打开的工作簿名称:" + table.name)

    all_content = []
    for i in range(table.nrows):
        row_content = []
        for j in range(table.ncols):
            cell_value = table.cell(i, j).value
            row_content.append(cell_value)
        all_content.append(row_content)
    return all_content


if __name__ == '__main__':
    all_list = read_excel_data()
    for item in all_list:
        print(item)