如何在openpyxl中实现两列互连

import openpyxl

workbook = openpyxl.load_workbook('example.xlsx')
sheet = workbook['Sheet1']

column1 = sheet.iter_cols(min_col=1, max_col=1, values_only=True)
column2 = sheet.iter_cols(min_col=2, max_col=2, values_only=True)

new_column = []
for value1, value2 in zip(column1, column2):
    new_column.append((value1[0], value2[0]))

for index, (value1, value2) in enumerate(new_column, start=1):
    sheet.cell(row=index, column=3).value = f'{value1} - {value2}'

workbook.save('example_modified.xlsx')