上一页 1 ··· 10 11 12 13 14 15 16 17 18 ··· 96 下一页
摘要: import osimport xlwtfile_dir = 'c:/'os.listdir(file_dir)new_workbook = xlwt.Workbook()worksheet = new_workbook.add_sheet("new_test")n = 0for i in os.l 阅读全文
posted @ 2021-01-01 17:42 干it的小张 阅读(124) 评论(0) 推荐(0)
摘要: import xlsxwriter as xwworkbook = xw.Workbook(r"D:\mycode\files\报表1.xlsx")sheet0 = workbook.add_worksheet("sheet0")for i in range(0, 300): sheet0.writ 阅读全文
posted @ 2021-01-01 17:12 干it的小张 阅读(110) 评论(0) 推荐(0)
摘要: mysql库中的数据 import xlrdimport xlwtfrom xlutils.copy import copyimport pymysqldatabase = pymysql.connect("127.0.0.1", "root", "123", "test11", charset=' 阅读全文
posted @ 2021-01-01 16:57 干it的小张 阅读(1272) 评论(0) 推荐(0)
摘要: 先查下后台数据 USE test12 SELECT * FROM `data` 代码如下: import pymysqldatabase = pymysql.connect("127.0.0.1", "root", "123", "test12", charset="utf8")cursor = d 阅读全文
posted @ 2021-01-01 16:36 干it的小张 阅读(118) 评论(0) 推荐(0)
摘要: 原表 import xlrdimport xlwtfrom xlutils.copy import copyxlsx = xlrd.open_workbook(r"D:\mycode\files\7月下旬入库表.xlsx")table = xlsx.sheet_by_index(0)all_data 阅读全文
posted @ 2020-12-31 19:59 干it的小张 阅读(676) 评论(0) 推荐(0)
上一页 1 ··· 10 11 12 13 14 15 16 17 18 ··· 96 下一页