鲨鱼辣椒的博客

1、创建py文件linux下touch 1.pywinodow下 type nul>1.py2、编写脚本import xlrdimport xlwta_set = set()wb = xlrd.open_workbook('D:\1.xlsx')sheet = wb.sheet_by_index(0)execl_copy = xlwt.Workbook()sheet1 = execl_copy.add_sheet('sheet1', cell_overwrite_ok=Tr

# 先下载需要用到的包pip install xlrdpip install xlwt# 导入包import xlrdimport xlwt# 载入需要读取的表wb = xlrd.open_workbook('知识库-20200810.xlsx')# 设置要读取的sheetsheet = wb.sheet_by_index(0)# 新建一个需要写入的表execl_copy = xlwt.Workbook()# 给新建的表增加一个sheet（注意这里的sheet名字，不要用中文）s