如何在不改变合并单元格的情况下用openpyxl删除excel中的列？

from openpyxl import load_workbook
from openpyxl.utils import get_column_letter

# 加载Excel文件
wb = load_workbook('example.xlsx')

# 选择工作表
ws = wb['Sheet1']

# 要删除的列索引
col_index = 3

# 删除指定的列
ws.delete_cols(col_index)

# 合并单元格的列范围
merged_cells = ws.merged_cells.ranges

# 对合并的列进行重新合并
for merged_range in merged_cells:
    start_col = merged_range.min_col
    end_col = merged_range.max_col
    if start_col <= col_index <= end_col:
        # 更新合并的范围，将删除的列排除在外
        new_range = f"{get_column_letter(start_col)}:{get_column_letter(col_index-1)}"
        ws.merge_cells(new_range)

# 保存修改后的Excel文件
wb.save('example_modified.xlsx')