如何使用python基于子串将数据从一个工作表导入到另一个工作表

import openpyxl

source_workbook = openpyxl.load_workbook('source.xlsx')
source_sheet = source_workbook['Sheet1']

target_workbook = openpyxl.load_workbook('target.xlsx')
target_sheet = target_workbook['Sheet1']

for row in source_sheet.iter_rows(min_row=2, values_only=True):
    if '子串' in row[0]:  # 根据子串条件筛选需要导入的数据
        target_sheet.append(row)  # 将符合条件的数据追加到目标工作表

target_workbook.save('target.xlsx')
target_workbook.close()

import openpyxl

source_workbook = openpyxl.load_workbook('source.xlsx')
source_sheet = source_workbook['Sheet1']

target_workbook = openpyxl.load_workbook('target.xlsx')
target_sheet = target_workbook['Sheet1']

for row in source_sheet.iter_rows(min_row=2, values_only=True):
    if '子串' in row[0]:
        target_sheet.append(row)

target_workbook.save('target.xlsx')
target_workbook.close()