def data_title(self, sheet, data_title_list, row, col_start_index=1): '''写入数据名称 @param data_title_list: 第一行为标题,这里输入的是一个list ''' if data_title_list and isinstance(data_title_list, list): index = col_start_index for data_title in data_title_list: self.write(sheet, row, index, data_title, data_title_style()) if len(utils.to_unicode(data_title)) * 367 > sheet.col(index).width: sheet.col(index).width = len(utils.to_unicode(data_title)) * 367 index += 1
def data_title(self, sheet, data_title_list, row, col_start_index=1): '''写入数据名称 @param data_title_list: 第一行为标题,这里输入的是一个list ''' if data_title_list and isinstance(data_title_list, list): index = col_start_index for data_title in data_title_list: self.write(sheet, row, index, data_title, data_title_style()) if len(utils.to_unicode(data_title)) * 367 > sheet.col( index).width: sheet.col(index).width = len( utils.to_unicode(data_title)) * 367 index += 1
def data_seq(self, sheet, seq, row, col=1): '''写入测试次数,判断seq是否等于Average,如果为整型,将以整型写入,如果为字符,将以字符写入''' try: seq = int(seq) font_colour = 0x08 except Exception: if seq == "Average": font_colour = 0x0A else: font_colour = 0x08 self.write(sheet, row, col, seq, data_seq_style(font_colour=font_colour)) if len(utils.to_unicode(str(seq))) * 367 > sheet.col(col).width: sheet.col(col).width = len(utils.to_unicode(str(seq))) * 367
def write_cell(self, sheet, value, row, col): '''写入单个cell''' self.write(sheet, row, col, value, cell_style()) if len(utils.to_unicode(value)) * 367 > sheet.col(col).width: sheet.col(col).width = len(utils.to_unicode(value)) * 367
def data_seq_bak(self, sheet, seq, row, style, col=1): '''写入测试次数,判断seq是否等于Average,如果为整型,将以整型写入,如果为字符,将以字符写入''' self.write(sheet, row, col, seq, style) if len(utils.to_unicode(str(seq))) * 367 > sheet.col(col).width: sheet.col(col).width = len(utils.to_unicode(str(seq))) * 367