From ba96096468bd0d8dd3e9efe4392503403f8cec87 Mon Sep 17 00:00:00 2001
From: hcj <1224667075@qq.com>
Date: Mon, 30 Sep 2024 18:44:43 +0800
Subject: [PATCH] =?utf8?q?=E5=A4=8D=E5=88=B6=E6=B7=BB=E5=8A=A0=E4=B8=AD?=
 =?utf8?q?=E6=96=87ID=E5=92=8Cstring=20=E5=8F=AF=E5=BF=AB=E6=8D=B7?=
 =?utf8?q?=E6=B7=BB=E5=8A=A0id=E5=92=8Cstring?=
MIME-Version: 1.0
Content-Type: text/plain; charset=utf8
Content-Transfer-Encoding: 8bit

---
 .../Language_xml/add_copy_sheet.py            | 94 +++++++++++++++++++
 1 file changed, 94 insertions(+)
 create mode 100644 tools/language_tool/Language_xml/add_copy_sheet.py

diff --git a/tools/language_tool/Language_xml/add_copy_sheet.py b/tools/language_tool/Language_xml/add_copy_sheet.py
new file mode 100644
index 000000000..07cbb16ff
--- /dev/null
+++ b/tools/language_tool/Language_xml/add_copy_sheet.py
@@ -0,0 +1,94 @@
+'''  
+Date: 2024-08-19 11:11:21  
+LastEditors: SnickerSun snickersun@163.com
+LastEditTime: 2024-09-06 17:17:43
+FilePath: /FD230/tools/language_tool/Language_xml/sheettool.py
+'''  
+import xlsxwriter
+import openpyxl  
+import os  
+import sys
+import argparse
+
+# 设置路径  
+# path = r"."  
+# os.chdir(path)  # 如果需要更改工作目录可以取消注释  
+id = sys.argv[1:]
+name = sys.argv[-1]
+# 文件名称  
+input_file = "language_custom.xlsx"  
+
+# 检查文件是否存在并删除  
+# if os.path.isfile(output_file):  
+#     os.remove(output_file)  
+
+parser = argparse.ArgumentParser(description='复制添加STR_ID and str')
+parser.add_argument('STR_ID', type=str, help='ID')
+parser.add_argument('str', type=str, help='STRING')
+
+args = parser.parse_args()
+
+# 创建一个新的 Excel 文件  
+workbook = openpyxl.load_workbook(input_file)  
+
+# 语言表
+languagelist = [ ["zh", "中文", "中文"],
+        [ "en", "English", "英语"],
+        [ "ja", "日本語", "日语"],
+        [ "ko", "한국어", "韩语"],				
+        [ "es", "Español", "西班牙语"],
+        [ "ru", "Русский", "俄语"],
+        [ "hr", "Hrvatski", "克罗地亚语"],
+        [ "de", "Deutsch", "德语"],
+        [ "pt", "Português", "葡萄牙语"],
+        [ "fr", "Français", "法语"],
+        [ "nl", "Nederlands", "荷兰语"],
+        [ "it", "Italiano", "意大利语"],
+        [ "cs", "Čeština", "捷克语"],
+        [ "el", "Ελληνικά", "希腊语"],
+        [ "hi", "हिन्दी", "印地语"],  			
+        [ "id", "Bahasa Indonesia", "印尼语"],
+        [ "ms", "Bahasa Melayu", "马来语"],
+        [ "pl", "Polski", "波兰语"],
+        [ "th", "ไทย", "泰语"],    				
+        [ "vi", "Tiếng Việt", "越南语"],
+        [ "fi", "Suomi", "芬兰语"],
+        [ "ro", "Română", "罗马尼亚语"],
+        [ "tr", "Türkçe", "土耳其语"],
+        [ "fa", "فارسی", "波斯语"],    		
+        [ "ar", "العربية", "阿拉伯语"], 		
+        [ "he", "עברית", "希伯来语"],  		
+        [ "uk", "Українська", "乌克兰语"],
+        [ "sv", "Svenska", "瑞典语"],
+        [ "uz", "O‘zbek", "乌兹别克语"],
+        ["az", "Azərbaycan dili", "阿塞拜疆语"]]
+
+# def read_worksheet(worksheet, filename):  
+#     """  
+#     从指定文件读取内容并写入指定工作表  
+#     """  
+#     worksheet.write_row('A1', headings)  # 写入表头  
+
+def get_languagename(code):
+    for l in languagelist:
+        if l[2] == code:
+            # print("language_"+l[0]+".txt")
+            return l[2]
+    return ""
+# if not os.path.exists("out") :
+#     os.makedirs("out")
+
+for i in workbook.sheetnames:
+    count=0
+    for ro in workbook[i].iter_rows(values_only=True):
+        count = count+1
+    count = count+1
+    sheet=workbook[i]
+    sheet.cell(row=count, column=1, value=args.STR_ID)
+    sheet.cell(row=count, column=2, value=args.str)
+    #workbook[i].write(count, 0, name)
+
+workbook.save(input_file)
+workbook.close()
+
+print("复制添加ID和string")
-- 
2.17.1