def readLanguageExcel(self, spath):
time1=datetime.datetime.now()
try:
self.wb = load_workbook(spath,True)
self.arr_sheet_names=self.wb.get_sheet_names()
except:
self.arr_sheet_names=[]
time2=datetime.datetime.now()
str1="read "+spath+" file taken "+ str(time2-time1)+" 秒"
log.logF("readXlsx.py","readLanguageExcel",str1)
def readETRoot(spath):
# etree=ET.parse(spath)
# return etree.getroot()
try:
file=open(file=spath,mode='r',encoding="utf-8")
str1=file.read()
file.close()
str2=RETool.xmlEscape(str1)
tree = ET.ElementTree(ET.fromstring(str2))
return tree.getroot()
except Exception as detaile:
log.logF("ETTool.py","readETRoot","error path="+str(spath)+" detaile="+str(detaile))
return None
