1 import openpyxl 2 import configparser 3 4 5 conf = configparser.ConfigParser() 6 7 conf.read("E:\Projects\work_11_25\\Utility機種対応知能化\\Network Extension\\NETX_ALL_010500_6\setupdir\lang\JPN\opnedef.str", encoding='shift_jis') 8 sections = conf.sections() 9 10 # ['common', 'StrTable0', 'StrTable1', 'StrTable2', 'StrTable3', 'StrTable4', 'StrTable5', 'StrTable6', 'StrTable7', 'StrTable8', 'StrTable9'] 11 12 wb = openpyxl.load_workbook("E:\Projects\work_11_25\\Utility機種対応知能化\\Utility機種対応仕様.xlsx") 13 14 ws = wb["NetworkExtension"] 15 16 17 18 with open("E:\Projects\work_11_25\\Utility機種対応知能化\\Network Extension\\NETX_ALL_010500_6\setupdir\lang\JPN\opnedef.str", "r", encoding="shift_jis") as f1: 19 lines = f1.readlines() 20 index_list = [] 21 for line in lines[4:]: 22 if '[' in line and ']' in line: 23 index_list.append(lines.index(line)) 24 25 index_list.append(len(lines) + 1) 26 kv_list = [] 27 options = [] 28 value = [] 29 for i in range(len(index_list) - 1): 30 items = lines[index_list[i]: index_list[i + 1] - 1] 31 for kv in items[1:]: 32 kv = kv.split('=') 33 options.append(kv[0]) 34 if kv == ['\n']: 35 kv.append('\n') 36 value.append(kv[1].strip()) 37 # print(options) 38 # print(value) 39 40 ws['E4'].value = lines[0]+lines[1]+lines[2] 41 # print("head完成") 42 43 44 n = 5 45 for a in options: 46 ws["D" + str(n)].value = a 47 n += 1 48 49 n = 5 50 for b in value: 51 ws["E" + str(n)].value = b 52 n += 1 53 54 m = 0 55 x = -1 56 for s in sections: 57 ws['C' + str(index_list[m] - x)].value = s 58 x += 2 59 m += 1 60 61 wb.save("test.xlsx")