catchzeng / localizable.strings2excel Goto Github PK

Python command line tool for conversion between iOS strings files and excel files & between android strings.xml files and excl files. & strings files to android strings.xml files.

License: MIT License

Python 100.00%

android-strings ios-localizable xls extract-strings android-localizable-files conversion android-xml python-command python excel

localizable.strings2excel's Introduction

Localizable.strings2Excel

Python command line tool for conversion between iOS strings files and excel files & between android strings.xml files and excl files. & strings files to android strings.xml files.

中文请点击

Features

Support convert iOS strings files to excel files.
Support convert excel files to iOS strings files.
Support convert android xml files to excel files.
Support convert excel files to android xml files.
Support convert iOS strings files to android xml files.

Version

V1.0.0

Required

1.Check python version

python version must be 2.x.

$ python --version
Python 2.7.10

2.Check pip(python package manager)

$ pip --version
pip 19.0 from /Library/Python/2.7/site-packages/pip (python 2.7)

if pip is not installed

curl https://bootstrap.pypa.io/pip/2.7/get-pip.py -o get-pip.py
sudo python get-pip.py

3.Install pyexcelerator

sudo pip install pyExcelerator

4.Install xlrd

sudo pip install xlrd

Usage

1.Convert iOS strings files to excel files.

$ python python/Strings2Xls.py -f examples/ios/ -t examples/output
Start converting
Convert examples/ios/ successfully! you can see xls file in examples/output/strings-files-to-xls_20190129_165830

2.Convert excel files to iOS strings files

$ python python/Xls2Strings.py -f examples/output/strings-files-to-xls_20190129_165830/ -t examples/ou
tput/

options: {'fileDir': 'examples/output/strings-files-to-xls_20190129_165830/', 'targetDir': 'examples/output/', 'excelStorageForm': 'multiple', 'additional': None
}, args: []

Start converting
Convert examples/output/strings-files-to-xls_20190129_165830/ successfully! you can see strings file in examples/output//xls-files-to-strings_20190129_171146

3.Convert android xml files to excel files

$ python python/Xml2Xls.py -f examples/android/ -t examples/output

options: {'fileDir': 'examples/android/', 'targetDir': 'examples/output', 'excelStorageForm': 'multiple'}, args: []

Start converting
Convert examples/android/ successfully! you can see xls file in examples/output/xml-files-to-xls_20190129_172938

4.Convert excel files to android xml files

$ python python/Xls2Xml.py -f examples/output/xml-files-to-xls_20190129_172938/ -t examples/output/

options: {'fileDir': 'examples/output/xml-files-to-xls_20190129_172938/', 'targetDir': 'examples/output/', 'excelStorageForm': 'multiple', 'additional': None}, args
: []

Start converting
Convert examples/output/xml-files-to-xls_20190129_172938/ successfully! you can xml files in examples/output//xls-files-to-xml_20190129_174207

5.Convert iOS strings files to android xml files.

$ python python/Strings2Xml.py -f examples/ios/en.lproj/ -t examples/output/

options: {'fileDir': 'examples/ios/en.lproj/', 'targetDir': 'examples/output/', 'additional': None}, args: []


Creating android file:examples/output//strings-files-to-xml_20190129_164122/Localizable.xml


Creating android file:examples/output//strings-files-to-xml_20190129_164122/InfoPlist.xml


Convert successfully! you can see xml files in examples/output//strings-files-to-xml_20190129_164122

ChangeLog

Thanks

localizable.strings2excel's People

Contributors

Stargazers

Watchers

Forkers

helloworld520 chenyongjunm luttemars tengsin kerasking wuyongqiang123 vicentliu wuzhiyong168 besttumi justinjing cyclonecat babywolf1992 sumalla mspviraj ubtechrobotics bryant1410 fanleesong maynardchizicheng cthunter marvin0118 hnny09 wenzhenxing dennisxiaoding stephanluo superqiang hhuahh light-bo alicwang hahage bosong beamchang zhangxiaoshan618 chpisces rosyka josephpoplar yidahis buguibu zhangle520 morristech zhangyaixuexi admains sico2sico iso9007 isangbill wucanqi terryck leykion ljh0210 kingkadienm conceptcon hwreal linguinan drcular luckzxf trozee goldzhou2003 tangfangyu shawn736 hirosimic holmeszhao goodworkgoodstudy fengpeihao cxystudio meilulu chuxieliu haijiaoliuhao91 jason-sq ashishrajvanshi01 mirwing denghaoming dianlanzs visualfy sdj0001 fishboil xianqiang-wang akzhou guojingbu zhaokang122 kelly8119 ygmtx junqingwuchu jspzzlei1986 luna-moonfang xieqi520 skytodmoon kevin007-fang kamilwindak yjianmu donglj0310 gpr321 huazaiwudi mafeng-bryant wiiale tinyandneo kevinxinsuilu workless sykehaoran manjunathshiv yangshiliang liric28

localizable.strings2excel's Issues

能支持复数互转吗？stringsdict(iOS) 和 plural(android)

iOS:
https://developer.apple.com/library/archive/documentation/MacOSX/Conceptual/BPInternational/StringsdictFileFormat/StringsdictFileFormat.html
https://medium.com/@vitaliikuznetsov/plurals-localization-using-stringsdict-in-ios-a910aab8c28c

Android:
https://developer.android.com/guide/topics/resources/string-resource

ImportError: No module named pyExcelerator

Traceback (most recent call last):
File "python/Xml2Xls.py", line 6, in
import pyExcelerator
ImportError: No module named pyExcelerator

导出的excel不对,生成.strings文件失败

导出的excel只有一列key值
excel生成 **.strings文件失败

因为我的excel里面包含了多语言,每个语言为一列,格式如下:

keyName	en	zh-Hans	zh-Hant	es
someKey	...	...	...	...
...
...

是否可以支持:
1.生成多语言的excel
2.从多语言的excel导出为**.strings文件

怎么多个ios 国际化文件转成一个excel ,一个excel 转成多个 ios 国际化文件呢

feature request：support python 3.x

ModuleNotFoundError: No module named 'Workbook'

报错在这：
ACEdeMBP:python leopard$ python Localizable.py -f ../ios/ -t ../xls/
Traceback (most recent call last):
File "Localizable.py", line 6, in
import pyExcelerator
File "/Library/Frameworks/Python.framework/Versions/3.6/lib/python3.6/site-packages/pyExcelerator/init.py", line 12, in
from Workbook import Workbook
ModuleNotFoundError: No module named 'Workbook'

使用pip3 install Workbook下载了还是报错找不到Workbook。
ACEdeMBP:python leopard$ pip3 install Workbook
Requirement already satisfied: Workbook in /Library/Frameworks/Python.framework/Versions/3.6/lib/python3.6/site-packages
Requirement already satisfied: xlutils in /Library/Frameworks/Python.framework/Versions/3.6/lib/python3.6/site-packages (from Workbook)
Requirement already satisfied: xlwt in /Library/Frameworks/Python.framework/Versions/3.6/lib/python3.6/site-packages (from Workbook)
Requirement already satisfied: xlrd>=0.7.2 in /Library/Frameworks/Python.framework/Versions/3.6/lib/python3.6/site-packages (from xlutils->Workbook)

没能从搜索引擎搜索到解决办法，求助。
这里是跟python版本相关么？我的是：
Python 3.6.3

文件未找到

Traceback (most recent call last):
  File "Localizable.py", line 71, in <module>
    main()
  File "Localizable.py", line 69, in main
    startConvert(options)
  File "Localizable.py", line 46, in startConvert
    (keys, values) = LocalizableStringsFileUtil.getKeysAndValues(path)
  File "/Users/Hares/Documents/Res/Store/Third/Localizable.strings2Excel/python/LocalizableStringsFileUtil.py", line 43, in getKeysAndValues
    file = codecs.open(path, 'r', 'utf-8')
  File "/System/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/codecs.py", line 884, in open
    file = __builtin__.open(filename, mode, buffering)
IOError: [Errno 2] No such file or directory: '../ios/zh-Hans.lproj/Localizable.strings'

若是直接在你的文件打开修改没有问题而我直接把项目语言文件夹拉进去覆盖后
run起来就报这错我检查过权限和所有人都是一样的不知道什么原因难道是编码?

针对plurals和array也无法解析

    <plurals name="wifi_tether_connected_summary">
        <item quantity="one">%1$d device connected</item>
        <item quantity="other">%1$d devices connected</item>
    </plurals>

生成出来的文件是空的

安装 pip 时报错

curl https://bootstrap.pypa.io/get-pip.py -o get-pip.py

python 版本是2.7，执行 sudo python get-pip.py 时一直报错，无法安装pip，我怀疑下载的get-pip.py 是 python3 的语法。

Traceback (most recent call last):
File "get-pip.py", line 24226, in
main()
File "get-pip.py", line 199, in main
bootstrap(tmpdir=tmpdir)
File "get-pip.py", line 82, in bootstrap
from pip._internal.cli.main import main as pip_entry_point
File "/tmp/tmpX9NOZq/pip.zip/pip/_internal/cli/main.py", line 60
sys.stderr.write(f"ERROR: {exc}")

SyntaxError: invalid syntax

转出来是乱码,无法识别

这个工具很好用,谢谢.免去了好多粘贴复制,,,现在有个问题是,韩语转出来是乱码的,无法识别..这个要怎么处理..

can't open file 'Localizable.py'

安装完pyexcelerator、xld组件后执行
python Localizable.py -f /Users/cc/iCloudCC/CC/iOSCode/PlanetStore/PlanetStore -t /Users/cc/Downloads/Localizables.xls

报错
python: can't open file 'Localizable.py': [Errno 2] No such file or directory

win10下面android转换不成功

感谢大神作品，不过我运行不成功。
1、步骤：
按照说明一步步来，cmd告诉我“Convert successfully! you can see xls file in xls/Localizable.xls”。但是我打开Localizable.xls文件发现是空的。
2、截图
运行截图如下http://note.youdao.com/noteshare?id=9cc80867b6e3538be831cc54f40e4439

针对android string.xml中有命名空间的，解析出来就有问题

针对string.xml中含有xliff的就有错误
希望整体格式保持不变
"Activity <xliff:g id="DDDDDDDD">%1$s</xliff:g> isn\'t responding."\n\n"Do you want to close it?"

<resources xmlns:xliff="urn:oasis:names:tc:xliff:document:1.2">
  <string name="AAAAAAA" msgid="XXXXXXX">"Activity <xliff:g id="DDDDDDDD">%1$s</xliff:g> isn\'t responding."\n\n"Do you want to close it?"</string>
  <string name="AAAAAAA" msgid="XXXXXXX">"Another <xliff:g id="BBBBBBB">%1$s</xliff:g>message</string>
</resources>