运行完 print(cell.row) ,后面的就一直运行不完,表格里数据比较多,是因为这个吗?


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')