weixin_44176363的博客

首先下载pymysql包 pip install pymysql 完整案例 import pymysql db = pymysql. pymysql.connect(host='127.01.01', port=3306, user='root', passwd='123', db='demo', charset='utf8') cursor = db.cursor()#创建链接对象 sql = "select * from demo.test" cursor.execute(sql) data = c

引入openpyxl包 可使用pip命令 pip install openpyxl 完整案例 import openpyxl as ops if __name__=='__main__': filePath = 'C:/Desktop/没有回溯信息的保单.xlsx'#注意斜杠 wb = ops.load_workbook(filePath)#打开excel ws = wb.get_sheet_by_name('sheet1')#选中sheet val = list(ws