# -*- coding: utf-8 -*-
import xml.dom.minidom
import pandas as pd
key_list=[]
value_list=[]
def readStrings():
dom = xml.dom.minidom.parse('strings.xml')
root = dom.documentElement
tags=dom.getElementsByTagName('string')
for t in tags :
key = t.getAttribute("name")
value = t.firstChild.data
#print(key,end="\t")
#print(value)
key_list.append(key)
value_list.append(value)
def saveStrings():
all_dict={'id':key_list,'Decript':value_list}
df = pd.DataFrame(all_dict)
with pd.ExcelWriter('strings.xls') as Writer:
df.to_excel(Writer,'Sheet1',index=False)
if __name__ == "__main__":
readStrings()
saveStrings()