如何使用python和openpyxl将整个excel列移动到其当前位置的左侧或右侧？

from openpyxl import load_workbook
from openpyxl.utils import get_column_letter

workbook = load_workbook('file.xlsx')
sheet = workbook['Sheet1']  # 假设要操作的表格名为Sheet1

column_to_move = 'B'  # 假设要移动的列为B列

move_direction = 'left'  # 可选值为'left'或'right'
move_distance = 2  # 假设要移动的距离为2列

def move_column(sheet, column_to_move, move_direction, move_distance):
    column_index = get_column_letter(sheet[column_to_move + '1'].column)

    if move_direction == 'left':
        target_index = column_index - move_distance
    elif move_direction == 'right':
        target_index = column_index + move_distance
    else:
        raise ValueError('Invalid move direction')

    sheet.move_range(f'{column_to_move}:{column_to_move}', cols=move_distance, translate=True)
    sheet.move_range(f'{get_column_letter(target_index)}:{get_column_letter(target_index)}', cols=-move_distance, translate=True)

move_column(sheet, column_to_move, move_direction, move_distance)

workbook.save('file_modified.xlsx')