配置文件的自动化更新（v2.1)

import openpyxl
import sys

wb_temp = openpyxl.load_workbook("E:Projectswork_11_25\Utility機種対応知能化\Utility機種対応仕様.xlsx")
wb_info = openpyxl.load_workbook("E:Projectswork_11_25\Utility機種対応知能化\Utility機種対応Input情報.xlsx")
wb_result = openpyxl.load_workbook("E:Projectswork_11_25\Utility機種対応知能化\Utility詳細設計書_テンプレート_結果記入.xlsx")


ws_base = wb_temp["Color Correct Utility"]
ws_code = wb_temp["LANGCode"]
ws_info = wb_info["Color Correct Utility"]

# 多国语情报：
language_code = [ws_base['B22'].value, ws_base['B25'].value, ws_base['B28'].value, ws_base['B31'].value,
                 ws_base['B34'].value, ws_base['B37'].value, ws_base['B40'].value, ws_base['B43'].value,
                 ws_base['B46'].value, ws_base['B49'].value, ]
# ['ENU', 'JPN', 'CHS', 'CHT', 'DEU', 'ESP', 'FRA', 'ITA', 'KOR', 'PTB']

# 多国语编码
language_encoding = {}
for l in range(3, 26):
    language_encoding.update({ws_code['B' + str(l)].value: ws_code['C' + str(l)].value})
# print(language_encoding)

# OS情报：
OS_info = [ws_base['B56'].value, ws_base['B57'].value]
# ['x86', 'x64']

path = ws_base['B4'].value
# setupdirOS情報Resource多国語情報ColorUtilityOclutl.ini

path_list_dic = {}
path_list = []

for os in OS_info:
    for lan in language_code:
        path_list_dic[lan + '_' + os] = path.replace('多国語情報', lan).replace('OS情報', os)
# print(path_list_dic)
# {'ENU_x86': 'setupdir\x86\Resource\ENU\ColorUtility\Oclutl.ini',
# 'JPN_x86': 'setupdir\x86\Resource\JPN\ColorUtility\Oclutl.ini',
# 'CHS_x86': 'setupdir\x86\Resource\CHS\ColorUtility\Oclutl.ini',
# 'CHT_x86': 'setupdir\x86\Resource\CHT\ColorUtility\Oclutl.ini',
# 'DEU_x86': 'setupdir\x86\Resource\DEU\ColorUtility\Oclutl.ini',
# 'ESP_x86': 'setupdir\x86\Resource\ESP\ColorUtility\Oclutl.ini',
# 'FRA_x86': 'setupdir\x86\Resource\FRA\ColorUtility\Oclutl.ini',
# 'ITA_x86': 'setupdir\x86\Resource\ITA\ColorUtility\Oclutl.ini',
# 'KOR_x86': 'setupdir\x86\Resource\KOR\ColorUtility\Oclutl.ini',
# 'PTB_x86': 'setupdir\x86\Resource\PTB\ColorUtility\Oclutl.ini',
# 'ENU_x64': 'setupdir\x64\Resource\ENU\ColorUtility\Oclutl.ini',
# 'JPN_x64': 'setupdir\x64\Resource\JPN\ColorUtility\Oclutl.ini',
# 'CHS_x64': 'setupdir\x64\Resource\CHS\ColorUtility\Oclutl.ini',
# 'CHT_x64': 'setupdir\x64\Resource\CHT\ColorUtility\Oclutl.ini',
# 'DEU_x64': 'setupdir\x64\Resource\DEU\ColorUtility\Oclutl.ini',
# 'ESP_x64': 'setupdir\x64\Resource\ESP\ColorUtility\Oclutl.ini',
# 'FRA_x64': 'setupdir\x64\Resource\FRA\ColorUtility\Oclutl.ini',
# 'ITA_x64': 'setupdir\x64\Resource\ITA\ColorUtility\Oclutl.ini',
# 'KOR_x64': 'setupdir\x64\Resource\KOR\ColorUtility\Oclutl.ini',
# 'PTB_x64': 'setupdir\x64\Resource\PTB\ColorUtility\Oclutl.ini'}
# if p[3:] == "_x64":
dic_x86 = {}
dic_x64 = {}
for k in language_code:
    dic_x86[k + '_x86'] = path_list_dic[k + '_x86']
    dic_x64[k + '_x64'] = path_list_dic[k + '_x64']
# {'ENU_x86': 'setupdir\x86\Resource\ENU\ColorUtility\Oclutl.ini', 'JPN_x86': 'setupdir\x86\Resource\JPN\ColorUtility\Oclutl.ini', 'CHS_x86': 'setupdir\x86\Resource\CHS\ColorUtility\Oclutl.ini', 'CHT_x86': 'setupdir\x86\Resource\CHT\ColorUtility\Oclutl.ini', 'DEU_x86': 'setupdir\x86\Resource\DEU\ColorUtility\Oclutl.ini', 'ESP_x86': 'setupdir\x86\Resource\ESP\ColorUtility\Oclutl.ini', 'FRA_x86': 'setupdir\x86\Resource\FRA\ColorUtility\Oclutl.ini', 'ITA_x86': 'setupdir\x86\Resource\ITA\ColorUtility\Oclutl.ini', 'KOR_x86': 'setupdir\x86\Resource\KOR\ColorUtility\Oclutl.ini', 'PTB_x86': 'setupdir\x86\Resource\PTB\ColorUtility\Oclutl.ini'}
# {'ENU_x64': 'setupdir\x64\Resource\ENU\ColorUtility\Oclutl.ini', 'JPN_x64': 'setupdir\x64\Resource\JPN\ColorUtility\Oclutl.ini', 'CHS_x64': 'setupdir\x64\Resource\CHS\ColorUtility\Oclutl.ini', 'CHT_x64': 'setupdir\x64\Resource\CHT\ColorUtility\Oclutl.ini', 'DEU_x64': 'setupdir\x64\Resource\DEU\ColorUtility\Oclutl.ini', 'ESP_x64': 'setupdir\x64\Resource\ESP\ColorUtility\Oclutl.ini', 'FRA_x64': 'setupdir\x64\Resource\FRA\ColorUtility\Oclutl.ini', 'ITA_x64': 'setupdir\x64\Resource\ITA\ColorUtility\Oclutl.ini', 'KOR_x64': 'setupdir\x64\Resource\KOR\ColorUtility\Oclutl.ini', 'PTB_x64': 'setupdir\x64\Resource\PTB\ColorUtility\Oclutl.ini'}


def add_x86():
    m = 0
    for p in dic_x86:
        with open(dic_x86[p], 'r', encoding=language_encoding[p[:-4]]) as f1:
            new_section_name = '[CCMVer' + str(ws_info['C3'].value) + ']'  # 获取H列单元格内容"section"
            # [CCMVer42.3]

            lst = f1.readlines()  # 读取每行信息
            if new_section_name+'
' in lst:
                print("该section已添加过，无需添加。")
                sys.exit(0)
            # #
            n = lst.index('[StringSet1]
')  # 获取"[StringSet1]"的索引
            lst.insert(n, new_section_name + '
')  # 将新section按照索引值插入列表中
            if ws_info['C8'].value == 'Default':
                for i in range(5, 12):
                    n = n + 1
                    item = ws_base['D' + str(i)].value               # 获取item值
                    value = str(ws_info['C' + str(i-1)].value)         # 获取value值
                    if i == 8:
                        value = value + "
"
                    if i == 9:
                        value = str(ws_base['D' + str(22 + m)].value)
                    if i == 10:
                        value = str(ws_base['D' + str(23 + m)].value)
                    if i == 11:
                        value = str(ws_base['D' + str(24 + m)].value) + "
"
                        m += 3

                    lst.insert(n, item + " = " + value + '
')  # 将item值与value值按照索引插入列表中

            elif ws_info['C8'].value == 'A6':
                for i in range(5, 12):
                    n = n + 1
                    item = ws_base['D' + str(i)].value  # 获取item值
                    value = str(ws_info['C' + str(i - 1)].value)  # 获取value值
                    if i == 8:
                        value = value + "
"
                    if i == 9:
                        value = str(ws_base['E' + str(22 + m)].value)
                    if i == 10:
                        value = str(ws_base['E' + str(23 + m)].value)
                    if i == 11:
                        value = str(ws_base['E' + str(24 + m)].value) + "
"

                        m += 3
                    lst.insert(n, item + " = " + value + '
')         # 将item值与value值按照索引插入列表中
            print(lst)
        with open(dic_x86[p], 'w', encoding=language_encoding[p[:-4]]) as f2:
            f2.writelines(lst)


def add_x64():
    m = 0
    for p in dic_x64:
        with open(dic_x64[p], 'r', encoding=language_encoding[p[:-4]]) as f1:
            new_section_name = '[CCMVer' + str(ws_info['C3'].value) + ']'  # 获取H列单元格内容"section"
            # [CCMVer42.3]

            lst = f1.readlines()  # 读取每行信息
            if new_section_name+'
' in lst:
                print("该section已添加过，无需添加。")
                sys.exit(0)
            # #
            n = lst.index('[StringSet1]
')  # 获取"[StringSet1]"的索引
            lst.insert(n, new_section_name + '
')  # 将新section按照索引值插入列表中
            if ws_info['C8'].value == 'Default':
                for i in range(5, 12):
                    n = n + 1
                    item = ws_base['D' + str(i)].value  # 获取item值
                    value = str(ws_info['C' + str(i - 1)].value)  # 获取value值
                    if i == 8:
                        value = value + "
"
                    if i == 9:
                        value = str(ws_base['D' + str(22 + m)].value)
                    if i == 10:
                        value = str(ws_base['D' + str(23 + m)].value)
                    if i == 11:
                        value = str(ws_base['D' + str(24 + m)].value) + "
"
                        m += 3

                    lst.insert(n, item + " = " + value + '
')  # 将item值与value值按照索引插入列表中

            elif ws_info['C8'].value == 'A6':
                for i in range(5, 12):
                    n = n + 1
                    item = ws_base['D' + str(i)].value  # 获取item值
                    value = str(ws_info['C' + str(i - 1)].value)  # 获取value值
                    if i == 8:
                        value = value + "
"
                    if i == 9:
                        value = str(ws_base['E' + str(22 + m)].value)
                    if i == 10:
                        value = str(ws_base['E' + str(23 + m)].value)
                    if i == 11:
                        value = str(ws_base['E' + str(24 + m)].value) + "
"
                        m += 3
                    lst.insert(n, item + " = " + value + '
')  # 将item值与value值按照索引插入列表中
            print(lst)
        with open(dic_x64[p], 'w', encoding=language_encoding[p[:-4]]) as f2:
            f2.writelines(lst)


add_x86()
add_x64()