如何从xlsx中读取特定的列数据并更新到python中的js文件？

import openpyxl
import re

workbook = openpyxl.load_workbook('file.xlsx')
sheet = workbook['Sheet1']  # 根据实际工作表名称修改

column_data = []
column_index = None
for column in sheet.iter_cols():
    for cell in column:
        if cell.value == '特定列标题':  # 根据实际列标题修改
            column_index = re.findall(r'\d+', cell.coordinate)[0]
        if column_index and re.findall(r'\d+', cell.coordinate)[0] == column_index:
            column_data.append(cell.value)

with open('script.js', 'r') as file:
    lines = file.readlines()

with open('script.js', 'w') as file:
    for line in lines:
        if '特定列数据' in line:  # 根据实际需要更新的行进行匹配
            line = line.replace('特定列数据', ', '.join(column_data))
        file.write(line)