美文网首页
用python脚本将excel表格内容,生成多语言文本xx.st

用python脚本将excel表格内容,生成多语言文本xx.st

作者: gleeeli | 来源:发表于2023-05-23 16:51 被阅读0次

    完成demo可访问:https://github.com/gleeeli/PythonLocalizableProject

    excel表格.png 生成的iOS多语言文本.sting文件.png

    脚本内容:

    #coding=gbk
    
    import openpyxl
    
    
    from openpyxl import load_workbook
    
    # MineModule  LoginModule  PostModule MessageCenterModule MomentModule MineSetModule ConfigModule MessageListModule GoFishingModule SecretStoryModule
    # ['个人中心', '个人设置', '通用',']
    
    wb = load_workbook('./多语言中英文对照.xlsx')
    localModuleFilePath = "files/ConfigModule.strings"
    
    #获取工作表--Sheet
    # 获得所有sheet的名称
    print(str(wb.sheetnames))
    # 根据sheet名字获得sheet
    a_sheet = wb['通用']
    # 获得sheet名
    print(a_sheet.title)
    # 获得当前正在显示的sheet, 也可以用wb.get_active_sheet()
    sheet = wb.active
    def writeFileHead():
        with open(localModuleFilePath, 'a') as file_object:
            file_object.write("/*\n " +localModuleFilePath+"\n Pods\n Created by liguanglei on 2023/3/29.\n\n*/\n\n")
    
    def writeRowTofile(key, value):
        with open(localModuleFilePath, 'a') as file_object:
            file_object.write("\"" + key+"\" = \"" + value + "\";\n")
    
    
    writeFileHead()
    for row in a_sheet.values:
        key = str(row[0])
        chineseValue = str(row[1])
        chineseValue = chineseValue.replace("{count}","%s")
        yinhaoStr = "\\\""
        chineseValue = chineseValue.replace("\"", yinhaoStr)
        if key != "None" and key != "" and key != "Key值" and chineseValue != "None":
            print(key + "=" + chineseValue + "备注:" + str(row[2]))
            writeRowTofile(key, chineseValue)
    

    相关文章

      网友评论

          本文标题:用python脚本将excel表格内容,生成多语言文本xx.st

          本文链接:https://www.haomeiwen.com/subject/djbxedtx.html