摘要:
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 # ... 阅读全文
摘要:
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... 阅读全文