摘要: 1 import xlrd 2 book = xlrd.open_workbook('app_student.xls') 3 sheet = book.sheet_by_index(0) 4 # sheet2 = book.sheet_by_name('shee1') 5 # print(sheet.cell(0,0).value) #指定sheet页里面行和lie获取数据 6 # ... 阅读全文
posted @ 2018-05-11 21:24 暮色森森 阅读(179) 评论(0) 推荐(0) 编辑
摘要: 1 import pymysql,xlwt 2 def export_excel(table_name): 3 host, user, passwd, db = '118.24.3.40', 'jxz', '123456', 'jxz' 4 coon = pymysql.connect(user=user,host=host,port=3306,passwd=passwd... 阅读全文
posted @ 2018-05-11 21:23 暮色森森 阅读(176) 评论(0) 推荐(0) 编辑