如何使用python在excel中将列表头移动到特定值对应的行?请参考所附快照。

import openpyxl

workbook = openpyxl.load_workbook('your_file.xlsx')

worksheet = workbook['Sheet1']

header_row = None
for row in worksheet.iter_rows(min_row=1, max_row=1):
    for cell in row:
        if cell.value == '特定值':
            header_row = cell.row
            break
    if header_row is not None:
        break

worksheet.move_range(f'A1:{worksheet.max_column}1', rows=header_row-1)

workbook.save('your_file_modified.xlsx')