摘要: import pandas as pd # 先装个pandas ,pip install pandas import pymysql # 读入数据库 filename = 'student.xlsx' # 本地需要导入数据库的文件 data = pd.read_excel(filename) # 建 阅读全文
posted @ 2021-09-16 11:42 一笔一划82 阅读(479) 评论(0) 推荐(0)
摘要: 使用openpyxl库 from openpyxl import Workbook import pymysql con = pymysql.connect(host="127.0.0.1", port=3306, user="root", passwd="***", db="student",ch 阅读全文
posted @ 2021-09-16 11:00 一笔一划82 阅读(72) 评论(0) 推荐(0)