def parseMultipleFilessSheet(sheet, minrow, maxrow, mincol, maxcol, keycol,keyrow): lstrees,dictag,lasttag,endtag=[],{},None,None for tagrow in range(minrow,maxrow):#查找表格有多少个文件,并且记录每个文件的起始minrow,maxrow arrtag=[] try: cell = sheet.cell(row=tagrow,column=mincol-1) cellkey=sheet.cell(row=tagrow,column=mincol) except Exception as detaile: print(detaile) continue if(cell.column==None or cell.row==None or cell.value==None or cellkey.column==None or cellkey.row==None or cellkey.value==None): continue if(dictag.get(cell.value)!=None): continue if(lasttag==None or lasttag!=cell.value):#first one or different one arrtag.extend([cell.value,cell.row]) dictag[cell.value]=arrtag if(lasttag!=None): arrlasttag=dictag[lasttag] arrlasttag.extend([cell.row-1]) lasttag=cell.value endtag=cell.value if(endtag!=None): arrlasttag=dictag[endtag] arrlasttag.extend([maxrow]) for i,v in enumerate(dictag): arrtag=dictag[v] lstree=ETTool.createETRoot("root") parseSheetSimple.parseSimpleSheet(sheet,arrtag[1],arrtag[2],mincol,maxcol,keycol,keyrow,lstree) writeXml.writeXml("languageoutput/"+v+".xml",lstree) lstrees.append([v,lstree]) return lstrees
def parseSheet(self): lstree,lstrees=None,None for row in self.lsws.iter_rows(): for cell in row: if(cell.value==readConfig.keyColumn):#读取到 cell内容为 Key的关键字,表格开始解析 if(column_index_from_string(cell.column)==1 or (column_index_from_string(cell.column)>1 and self.lsws.cell(row=cell.row, column=column_index_from_string(cell.column)-1).value==None)):#cell.column=A, cell.row=1 #第一种类型的表格,表格的名字对应一个.xml,表格中只有key值,无需指定tag值 lstree=parseSheetSimple.parseSimpleSheet(self.lsws,cell.row+1,self.lsws.max_row,column_index_from_string(cell.column),self.lsws.max_column,column_index_from_string(cell.column),cell.row,None) self.files.append([self.lsws.title,lstree]) elif(column_index_from_string(cell.column)>=2 and self.lsws.cell(row=cell.row, column=column_index_from_string(cell.column)-1).value==readConfig.tagColumn): #第二种类型表格,表格的名字对应一个.xml,表格中有key值,tag值 lstree=parseSheetMultipleTags.parseMultipleTagsSheet(self.lsws,cell.row+1,self.lsws.max_row,column_index_from_string(cell.column),self.lsws.max_column,column_index_from_string(cell.column),cell.row) self.files.append([self.lsws.title,lstree]) elif(column_index_from_string(cell.column)>=2 and self.lsws.cell(row=cell.row,column=column_index_from_string(cell.column)-1).value==readConfig.fileColumn): #第三种类型表格,表格的名字无意义,表格中含有导出的.xml文件名,tag值 lstrees=parseSheetMultipleFiles.parseMultipleFilessSheet(self.lsws,cell.row+1,self.lsws.max_row,column_index_from_string(cell.column),self.lsws.max_column,column_index_from_string(cell.column),cell.row) self.files.extend(lstrees) return