openpyxl read excel

最新推荐文章于 2024-05-20 20:26:39 发布

weixin_34072637

最新推荐文章于 2024-05-20 20:26:39 发布

阅读量142

点赞数

文章标签： python 数据库

原文链接：https://my.oschina.net/u/3238650/blog/2996685

版权

2019独角兽企业重金招聘Python工程师标准>>>

#!/usr/bin/python
# -*- coding: UTF-8 -*-
import pymysql
from openpyxl import load_workbook

# sql=" select * from saas_school_type where schoolId=3408260001  "
updateSql=" update saas_school_type set customerService=%s where schoolId=%s "
db = pymysql.connect(host = 'rdsmrrjuqmrrjuq758.mysql.rds.aliyuncs.com', port = 3268, user = 'zl_cicada', passwd = '04zHiliao_01', db = 'kidscare', charset="utf8")
cursor = db.cursor()
# cursor.execute(sql)
# sqlList = cursor.fetchone()
# print(sqlList[0])

wb = load_workbook(filename='/Users/chanming/Desktop/园所匹配客成-1219.xlsx', read_only=True)
ws = wb['Sheet1']
sn={}
for row in ws.rows:
	sn[row[0].value]=row[2].value

for key,value in sn.items():
	print(key),
	print(value)
	cursor.execute(updateSql,(value,key))
db.commit()
cursor.close()
db.close()

转载于:https://my.oschina.net/u/3238650/blog/2996685