摘要:
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)