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