write_excel.py 文件源码

def write_model_value(self,mod_name,loop,dstReport):
        #print 'Fuction write_model_value'
        row = self.start_module_row + self.mod_row_offset
        keyword = None
        for x in range(0,9):
            Hylink_Flag = False
            if x ==0:
                keyword = self.dstRst_total_mod['DoneNum']
            elif x ==1:
                keyword = dstReport['ScriptName']
                #keyword = '.\\'+dstReport['ScriptName'].split('\\')[-2] + '\\'+self.fill_txt(dstReport['ScriptName'])
                Hylink_Flag = True
            elif x ==2:
                keyword = '.\\'+dstReport['ScriptRestName'].split('\\')[-2] + '\\'+self.fill_txt(dstReport['ScriptRestName'])
            elif x ==3:
                keyword = dstReport['ScriptRestName']
                Hylink_Flag = True
            elif x ==4:
                keyword = self.get_log_file(dstReport['ScriptRestName'])
                Hylink_Flag = True
            elif x ==5:
                keyword = dstReport['Result']
            else:
                keyword =''
            if Hylink_Flag==True:
                tmp_str_path ='\\\\'.join(keyword.split('\\'))
                if x==3:
                    tmp_st2 = self.fill_txt(dstReport['ScriptRestName'])
                    try:
                        self.sheet.write_merge(row,row,x,x,xlwt.Formula("HYPERLINK" +  '("'+tmp_str_path+'";"'+tmp_st2+'")'),self.style6)
                    except Exception ,e:
                        log_print(e)
                elif x ==1:
                    tmp_st2 = self.fill_txt(dstReport['ScriptName'])
                    try:
                        self.sheet.write_merge(row,row,x,x,xlwt.Formula("HYPERLINK" +  '("'+tmp_str_path+'";"'+tmp_st2+'")'),self.style11)
                    except Exception,e:
                        log_print(e)
                else:
                    tmp_st2 = self.fill_txt(dstReport['ScriptRestName'])
                    try:
                        self.sheet.write_merge(row,row,x,x,xlwt.Formula("HYPERLINK" +  '("'+tmp_str_path+'";"'+tmp_st2+'")'),self.style7)

                    except Exception ,e:
                        log_print(e)
            else:
                self.sheet.write(row,x,keyword,self.style1)
        self.dstRst_total_mod['DoneNum'] = str(self.mod_row_offset)
        try:
            dstReport['Result'].find(KEY_RESULT_OK)
        except Exception,e:
            log_print(e)

        if (dstReport['Result'].find(KEY_RESULT_OK))>-1:
            self.dstRst_total_mod['OKNum'] = str(string.atoi(self.dstRst_total_mod['OKNum']) + 1)
        else:
            self.dstRst_total_mod['NGNum'] = str(string.atoi(self.dstRst_total_mod['NGNum']) + 1)
        self.write_model_done(row-self.mod_row_offset)