PythonAutomation/StringXml2excelI18n.py at master · bayshier/PythonAutomation · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
#!/usr/bin/env python
# -*- coding: utf-8 -*-
import datetime
import os
import xml.dom.minidom
import xlwt
import xlrd


# strings.xml 转 Excel.xls
# fileList传的第一个文件为默认的strings.xml文件，以该文件的KEY为基准去对应的匹配各个语言内容
def export2Excel(fileList):
    languageIndex = 0  # 语言标题的角标
    FILE_TITLE = 'Android-strings翻译文档'
    # 获取当前时间
    today = datetime.date.today()
    # workbook = xlsxwriter.Workbook(FILE_TITLE + today.__str__() + '.xlsx')
    # worksheet = workbook.add_worksheet()

    workbook = xlwt.Workbook(encoding='utf-8')
    worksheet = workbook.add_sheet(FILE_TITLE + today.__str__(), cell_overwrite_ok=True)

    for file in fileList:
        languageIndex += 1

        # 使用minidom解析器打开 XML 文档
        DOMTree = xml.dom.minidom.parse(file)
        collection = DOMTree.documentElement
        strings = collection.getElementsByTagName("string")

        # 从第一个单元格开始，行和列的索引均为0
        row = 1
        col = 0
        # 写标题
        worksheet.write(0, 0, "键")
        worksheet.write(0, languageIndex, os.path.splitext(file)[0])

        # 迭代数据并逐行写入
        # fo    r cost in (expenses):
        for i, q in enumerate(strings):
            if len(q.childNodes) > 0:
                # 默认的语言
                if languageIndex == 1:
                    worksheet.write(row, col, q.getAttribute("name"))  # 写KEY
                    worksheet.write(row, languageIndex, q.childNodes[0].data) # 写VALUE
                    row += 1
                # 其它语言以默认语言的KEY为标准填充各种的VALUE
                else:
                    data = xlrd.open_workbook(FILE_TITLE + today.__str__() + '.xls') # 打开excel文件
                    tab = data.sheet_by_index(0)  # 选择excel里面的Sheet
                    nrows = tab.nrows  # 行数
                    # ncols = tab.ncols  # 列数
                    for innerRow in range(0, nrows):
                        print(str(tab.cell(innerRow, 0).value))
                        if str(tab.cell(innerRow, 0).value) == str(q.getAttribute("name")):
                            # worksheet.write(innerRow, col, q.getAttribute("name"))  # 写KEY
                            worksheet.write(innerRow, languageIndex, q.childNodes[0].data)  # 写VALUE

                        else:
                            continue #其它语言的KEY如果多的不添加
                            # ncols +=1
                            # print(ncols, col, languageIndex)
                            # worksheet.write(ncols, col, q.getAttribute("name"))  # 写KEY
                            # worksheet.write(ncols, languageIndex, q.childNodes[0].data)  # 写VALUE
        workbook.save(FILE_TITLE + today.__str__() + '.xls')  # 保存文件
    print(FILE_TITLE + today.__str__() + '.xls', '导出成功')


# 获取该文件夹下的各个strings.xml文件
def stringXmlToexcelI18n(file_dir):
    language_index = 0
    fileList = []
    for root, dirs, files in os.walk(file_dir):
        for file in files:
            # if os.path.splitext(file)[1] == '.xml' and os.path.splitext(file)[0].find('strings') != -1:
            if os.path.splitext(file)[1] == '.xml' and os.path.splitext(file)[0].find('strings') != -1:
                print(file)
                language_index += 1
                fileList.append(file)
    # print(fileList.__str__())
    export2Excel(fileList)


# StringXml2excelI18n(os.getcwd())