一键替换8国文言

1，创建待改的表格格式，命名为m_strings.xlsx，文档里的格式如下
语言
键
修改的值

cn
app_name
lalal

eu
app_name
ai_aaa

fr
app_name
ai_lalalala

2，将m_strings.xlsx放在xxx目录下，在xxx目录下创建cn,eu,fr等文件夹，将对应的strings.xml文件放到对应目录下

3，执行asstrings.py

附代码

from openpyxl import load_workbook
import sys
import os
import xml.etree.ElementTree as ET

def open():
    path = sys.path[0]+"\\strings\\m_strings.xlsx"
    data_excel = load_workbook(path)
    sheet = data_excel.worksheets[0]
    columns = sheet.rows
    for row in columns:
        co_val = [row.value for row in row]
        sub_path = sys.path[0]+"\\strings\\"+co_val[0]+"\\"
        if os.path.exists(sub_path):
            update(sub_path,co_val[1],co_val[2])
      

def update(path,key,m_value):
    #打开xml文档
    print('path='+path+",key="+key+",value="+m_value)
    xml_path = path+'strings.xml'
    dom = ET.parse(xml_path)
    # 获取根元素
    root = dom.getroot()
    # 获取string列表
    resource = root.findall('string')

    for node in resource:
        # 得到名称
        name = node.get('name')
        # 得到对应的值 
        value = node.text
        if key == name:
            node.text = m_value
            print('node:'+node.text)
            dom.write(xml_path,encoding='utf-8')
   

if __name__=='__main__':
    open()