getListForFilename (sheet_name ,bw_row, bw_index ) get_index_kw ( 100, bw_row, 'bw', sheet_name ) getListForFilename (sheet_name ,imgs, band_index ) for bw_row in bw_imgs :īw_index = self. get_index_kw ( 100, imgs, 'band', sheet_name )īw_imgs = self. append (r_f ) else : for r_index in range (row_cun ) : Row_cun = int ( len (r_f ) / 4 ) if row_cun = 0 : getListForFilename (sheet_name ,imgs, 3, True ) for r_f in scc_files : append (id_row ) elif 'CA' in loca_mame : append (titles + ' ' +titles + ' ' +titles ) extend (b_id_list ) for id_row in b_id_files : getListForFilename (sheet_name ,b_row, - 1, True )ī_id_files. extend (b_list ) for b_row in band_files :ī_id_list = self. getListForFilename (sheet_name ,tc_row, 1, True )īand_files.
getListForFilename (sheet_name ,imgs, 0 ) for tc_row in tc_files :ī_list = self. Sheet_imgs = if 'mars test' in loca_mame. keyword_dict if sheet_name in location_keyword : startswith (kw ) :ĭef sort_imgs (self ,sheet_name ,imgs ) : startswith ( 'ANT' ) :īreak else : for p_index ,p in enumerate (pars ) : if p. band_dict :īreak elif kw = 'a' : for p_index ,p in enumerate (pars ) : if p. split ( ' ' ) if kw = 'band' : for p_index ,p in enumerate (pars ) : if p in self. upper ( ) ) else : return 100 def get_index_kw (self ,defaut_i ,imgname ,kw ,sheetname ,isExts = False ) : upper ( ) : return i + 1 return def sort_kw_wifi (self ,kw ) : if kw. upper ( ) : return i + 1 return def getKWCol (self ,ws ,itemrowindex ,kw ) : for i in range ( 50 ) : writeSheet (wb ,product ,data ,sheetname ,file_keyword ,standalone_keyword ,is_plot = True ,rewrite = True ) def getItemRowIndex (self ,ws ,nrows ) : for i in range (nrows ) : writeSheet (wb ,product ,new_data ,sheetname ,file_keyword ,standalone_keyword ,is_plot = True ,rewrite = True ) else : my_strip (row_data ) not in group_list : continue my_strip (row_data ) not in group_list : continue else : if index > 1 and self. my_strip (row_data ) not in config_list and self. split ( ',' ) ) for index ,row_data in enumerate (data ) : if x_config :Ĭonfig_list = self. split ( 'Comparison_' ) Ĭ_config_col = self. collect ( ) print (xlsx_name, ' Finish' ) def imgRow_check (self ,img_row ) : # check * empty for img_file in img_row : if img_file != 'isKp' : return True return False def writePlotData (self ,wb ,sheetname ,report_name ,comparison = False ) : # ws = wb.add_worksheet(sheetname)įile_keyword = self.
close ( ) print ( 'aaaaaaaaaaaaa' ) if ws_exist : del wb ,ws writePlotData (wb ,sname ,xlsx_name ) print ( 'save ' ,xlsx_name ) set_tab_color ( '1072BA' ) if new_sheets : for sname in new_sheets : keyword_dict = readKeyword (keyword_file ). # show, legend, text, plot from xlsxwriter import WorkbookĬlass writeData ( object ) : def _init_ (self, filepath, outpath, comparison, read_csv ,screen ,select_keep ,ui ) :
utils import get_column_letterįrom CDF_draw_pic_v4 import output_pictureįrom CDF import output_picture as cdf_pictureįrom PDF import output_picture as pdf_pictureįrom Comparison_CDF import output_picture as comp_CDFįrom Comparison_PDF import output_picture as comp_PDFįrom pylab import savefig, xlim, figure, \
styles import Font ,Alignmentįrom openpyxl. From DesenseGeneral import desenseGeneralįrom openpyxl.