摘要: 原表 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的小张 阅读(637) 评论(0) 推荐(0) 编辑
摘要: import xlwtnew_workbook = xlwt.Workbook()worksheet = new_workbook.add_sheet("new_test")worksheet.write(0, 0, "test")new_workbook.save(r"D:\mycode\file 阅读全文
posted @ 2020-12-31 15:32 干it的小张 阅读(77) 评论(0) 推荐(0) 编辑
摘要: import xlrdimport osxlsx = xlrd.open_workbook(r'D:\mycode\files\7月下旬入库表.xlsx')# 用索引table = xlsx.sheet_by_index(0)# 用工作表名# table = xlsx.sheet_by_name(" 阅读全文
posted @ 2020-12-31 15:25 干it的小张 阅读(126) 评论(0) 推荐(0) 编辑