Export XCode string files to excel

export.py

import fnmatch
import os
import xlsxwriter
import collections

texts = {}

for root, dirnames, filenames in os.walk('./YourAwesomeProject/'):
    for filename in fnmatch.filter(filenames, '*.strings'):
    	dirs = root.split("/")
    	lang = dirs[len(dirs)-1]
    	if not filename in texts:
    		texts[filename] = {}

    	if not lang in texts[filename]:
    		texts[filename][lang] = {}

    	with open(os.path.join(root, filename)) as f:
    		content = f.readlines()
    		for item in content:
    			parts = item.split("=")
    			if (len(parts) == 2):
	    			key = parts[0].strip()[1:-1]
	    			value = parts[1].strip()[1:-2]
	    			texts[filename][lang][key] = value

#export exels file
COL = []
for i in range(ord('A'), ord('Z') + 1):
	COL.append(chr(i))
for i in range(ord('A'), ord('Z') + 1):
	COL.append('A' + chr(i))


workbook = xlsxwriter.Workbook('lang.xlsx')
for sheet in texts:
	worksheet = workbook.add_worksheet(sheet)
	langKeylist = texts[sheet].keys()
	langKeylist.sort()
	lang_index = 1

	allTextInLang = []
	allTextInLangDict = {}

	for lang in langKeylist:
		col = COL[lang_index] + "1"
		worksheet.write(col, lang)
		lang_index += 1

		for key in texts[sheet][lang]:
			if not allTextInLangDict.has_key(key):
				allTextInLangDict[key] = True
				allTextInLang.append(key)
	allTextInLang.sort()

	for i in range(len(allTextInLang)):
		_key = allTextInLang[i]
		worksheet.write(COL[0] + `(i+2)`, _key.decode('utf-8', 'ignore'))
		for j in range(len(langKeylist)):
			_lang = langKeylist[j]
			if texts[sheet][_lang].has_key(_key):
				worksheet.write(COL[j + 1] + `(i+2)`, texts[sheet][_lang][_key].decode('utf-8', 'ignore'))



workbook.close()