from openpyxl import load_workbook,Workbook
x_file = load_workbook(r'F:\三月\05_1标准型.xlsx',data_only = True)
sheet=x_file['05_1标准型']
colA = sheet['E']
# 接下来筛选符合条件的行
row_list = []
for cell in colA:
if isinstance(cell.value,int) and cell.value == 3701033113:
print(cell.row)
row_list.append(cell.row)
new_workbook = Workbook()
new_sheet = new_workbook.active
# 从旧表中根据行号提取符合条件的行,并遍历单元格获取值,以列表形式写入新表
for row in row_list:
data_list = []
for cell in sheet[row]:
data_list.append(cell.value)
new_sheet.append(data_list)
new_workbook.save(r'F:\三月\筛选表.xlsx')