python批量将包含某某的数据找到并整理成新的表格.zip

from openpyxl import load_workbook, Workbook filepath = r'C:\Users\Administrator\Desktop\aaa.xlsx' # 需要修改:总表的路径 workbook = load_workbook(filepath) new_workbook = Workbook() # 创建新的Excel工作簿获取到工作表 new_sheet = new_workbook.active new_headers = ['编号', '数值'] #给新表写入表头 new_sheet.append(new_headers) for i in workbook.sheetnames: sheet = workbook[i] names = sheet['A'] #从那一列检索 flag = 0 for cell in names: if cell.value == "c": #需要修改：这里的"c"就是要提取的内容标签 flag = cell.row break if flag: # 如果flag没有被修改则不需要顺序进行下列代码 data_lst = [] for cell in sheet[flag]: if cell.value: # 这里加上一个对内容的判断，是让无内容的行直接放空，而不是写入一个none data_lst.append(str(cell.value)) else: data_lst.append(' ') new_sheet.append(data_lst) new_workbook.save(r'C:\Users\Administrator\Desktop\bbb.xlsx') #需要修改：新的工作蒲保存到哪里；