摘要: 写excel--xlwt模块 import xlwt # book = xlwt.Workbook() # sheet = book.add_sheet('students1') # sheet.write(0,0,'id') # sheet.write(0,1,'name') # sheet.wr 阅读全文
posted @ 2020-09-12 20:25 Mezhou 阅读(121) 评论(0) 推荐(0) 编辑
摘要: import pymysql host='127.0.0.1' user = 'jxz' password = '123456'#字符串 db = 'jxz' port = 3306#int类型 connect = pymysql.connect(host=host,port=port,db=db, 阅读全文
posted @ 2020-09-12 20:18 Mezhou 阅读(84) 评论(0) 推荐(0) 编辑
摘要: l = ['a','b','c','d','e','f'] for i in enumerate(l):#枚举函数 print(i) for index,item in enumerate(l):#枚举函数 print(index,item)#打印索引和值 运行结果: 阅读全文
posted @ 2020-09-12 20:14 Mezhou 阅读(115) 评论(0) 推荐(0) 编辑
摘要: import yamail # import yagmail #发附件的附件如果是中文名是乱码 username = 'testing_dhcc@163.com' passwd = 'aaaaaaa'#授权码 # smtp = yamail.SMTP(host='smtp.qq.com', # us 阅读全文
posted @ 2020-09-12 20:12 Mezhou 阅读(107) 评论(0) 推荐(0) 编辑