筛选表格中某列数据并在当前表格新建sheet 表格常规操作备忘 # coding=utf-8 import xlrd import xlwt from xlutils.copy import copy file = 'F:\xxxxx.xlsx' word_key = [str(input("请输入关键字:"))