在根据范围"F“值插入行之后，从范围"H”复制值

import openpyxl

# 打开Excel文件
workbook = openpyxl.load_workbook('example.xlsx')

# 选择要操作的工作表
worksheet = workbook['Sheet1']

# 根据范围"F"的值，找到对应的行号
f_value = 'some_value'  # 替换为实际的范围"F"的值
row_number = None
for row in worksheet.iter_rows(min_row=1, max_row=worksheet.max_row, min_col=6, max_col=6):
    for cell in row:
        if cell.value == f_value:
            row_number = cell.row
            break

# 在找到的行的下方插入新的一行
worksheet.insert_rows(row_number + 1)

# 根据范围"H"的值，找到对应的列号
h_value = 'some_value'  # 替换为实际的范围"H"的值
column_number = None
for column in worksheet.iter_cols(min_row=row_number, max_row=row_number, min_col=8, max_col=8):
    for cell in column:
        if cell.value == h_value:
            column_number = cell.column
            break

# 复制范围"H"的值到新插入的行中
for row in worksheet.iter_rows(min_row=row_number, max_row=row_number, min_col=column_number, max_col=column_number):
    for cell in row:
        new_cell = worksheet.cell(row=row_number + 1, column=cell.column)
        new_cell.value = cell.value

# 保存更改
workbook.save('example.xlsx')