python 写excel（1）

这个脚本完成的内容是：读取一个log中的内容，将其中的部分内容获取，并按照一定规则将其填入excel

import re,osimport xlrdimport xlwtfrom xlwt import *from xlutils.copy import copygen_excel_file = "./find_force.log"class gen_excel:    def __init__(self):        self._excel_list=[]        self._excel_dict = {}        self._tempcaseName = None     #在这里使用self定义的变量，实际上都是整个类都在使用的全局变量，所以这里不能将templine搞成全局变量     #   self._tempLine = ''    def option_parse(self):        pass    def extract_excel(self,file):        for line in open(file):            if (line.startswith('/vobs/eagle2-xg746-prj/test/src') and line != self._tempcaseName):                tempcaseName = line                #这句是将上line指向的字符串按照/test/src/分割返回一个列表，0-第一个字符，-1最后一个字符                excel_element=line.split('/test/src/')[-1]                tempLine = ''            if ('force' in line):                 tempLine = tempLine + line                 forceContL = len(tempLine)#这里用了这样的一个的if判断，好像是因为当字符串长度如果大于某一长度时，就无法放入excel的表格里了，这一长度是和excel 的版本有关系的                 if(forceContL < 32767):#                    print (excel_element)                    self._excel_dict[excel_element] = tempLine +'\n'                    latestforceCont = tempLine                    for (k,v) in self._excel_dict.items():                        print(k)                        print(v)                    print('-----------')                 else:                     print 'force contents have long characters pls go to testcase file... '                     #self._excel_dict[excel_element] = 'force contents have long characters pls go to testcase file'+'\n'                     self._excel_dict[excel_element] = latestforceCont        print self._excel_dict    def initial_excel(self):        nRow = 0        nCol = 0        Title_report=['CaseName','ForceContent','Comment']        pattern_title=xlwt.Pattern()        pattern_title.pattern=xlwt.Pattern.SOLID_PATTERN        pattern_title.pattern_fore_colour=5        style_title=xlwt.XFStyle()        style_title.pattern=pattern_title    #workbook 是xlwt模块内置的一种方法，大约是设置初始格式的方法        excel_table=Workbook()        excel_sheet_report=excel_table.add_sheet("Force_Report")        row=1        column_report=0  #write 是向excel表格中写数据的方法，其输入参数依次是，行、列、内容、style        for element in Title_report:           excel_sheet_report.write(0,column_report,element,style_title)            column_report+=1        for (k,v) in self._excel_dict.items():            nRow +=1            nCol  +=1            excel_sheet_report.write(nRow,0,k)            excel_sheet_report.write(nRow,1,v)            excel_table.save('force_grep.xls')if __name__=="__main__":    excel_obj=gen_excel()    excel_obj.extract_excel(gen_excel_file)    excel_obj.initial_excel()

log内容

/vobs/eagle2-xg746-prj/test/src/host/flow/cp_phy_2g140:force {/CHIP_TB_SOC/INST_CHIP/INST_BD_SCAN/EDT_TOP_CPI_I/INST_CORE/INST_PHY_TOP/INST_PHY_CORE/INST_PHY_PER_SHELL/INST_DSP_2G_SUPER/MOD_I_RESET_VEC_I(2 downto 0)}  111 -freeze141:force {/CHIP_TB_SOC/INST_CHIP/INST_BD_SCAN/EDT_TOP_CPI_I/INST_CORE/INST_PHY_TOP/INST_PHY_CORE/INST_PHY_PER_SHELL/INST_DSP_2G_SUPER/MOD_O_RESET_VEC_I(2 downto 0)}  111 -freeze/vobs/eagle2-xg746-prj/test/src/host/flow/l2c_noc_access132:force /CHIP_TB_SOC/INST_CHIP/INST_BD_SCAN/EDT_TOP_CPI_I/INST_CORE/INST_CPI_L2C_NOC_SHELL/INST_CPI_L2C_NOC_TOP/INST_INTERCO_L2COPROC1_WRP/INST_INTERCO_L2COPROC1/l2c_noc1_inst/inst_pd_l2c_noc1_sw_emac_tile0_dig_main_wrapper/emac_tile0/fw_emac_tile0_slave_inst/mnoc_ni_fw_emac_tile0_slave_fw_rds_inst/fw_sec_check_err_o 0/vobs/eagle2-xg746-prj/test/src/host/flow/flow_tbic_cjtag_00184:force /CHIP_TB_SOC/INST_CHIP/INST_BD_SCAN/INST_CPI_TCU_TOP/JTAG_TRSTN_I 1186:force /CHIP_TB_SOC/INST_CHIP/INST_BD_SCAN/EDT_TOP_CPI_I/INST_CORE/INST_DFX_AGG/dfxagg_fdfx_earlyboot_exit 1187:force /CHIP_TB_SOC/INST_CHIP/INST_BD_SCAN/EDT_TOP_CPI_I/INST_CORE/INST_DFX_AGG/dfxagg_fdfx_policy_update_int 1188:force {/CHIP_TB_SOC/INST_CHIP/INST_BD_SCAN/EDT_TOP_CPI_I/INST_CORE/INST_DFX_AGG/dfxagg_fdfx_secure_policy[3:0]} 0100/vobs/eagle2-xg746-prj/test/src/host/toplevel/baseia/ia_flowtest_core1_lmuboot118:force /CHIP_TB_SOC/INST_CHIP/INST_BD_SCAN/EDT_TOP_CPI_I/INST_CORE/INST_CPI_XBCPU_MACRO_SHELL/INST_CPI_XBCPU_MACRO_TOP/INST_XBCPU_MACRO_WRP/INST_XBCPU_MACRO/subsys_xg756_test_bootmode_cpu1_i 1122:force /CHIP_TB_SOC/INST_CHIP/INST_BD_SCAN/EDT_TOP_CPI_I/INST_CORE/INST_CPI_XBCPU_MACRO_SHELL/INST_CPI_XBCPU_MACRO_TOP/INST_XBCPU_MACRO_WRP/INST_XBCPU_MACRO/inst_cpu_shell_vdd_wrapper/inst_cpu_shell/ia_subsys/bia/ssa_par/grp_ssa/ssa_core_top/ssa_core/bunit/bcfg_pmimr0_en 0125:force /CHIP_TB_SOC/INST_CHIP/INST_BD_SCAN/EDT_TOP_CPI_I/INST_CORE/INST_CPI_XBCPU_MACRO_SHELL/INST_CPI_XBCPU_MACRO_TOP/INST_XBCPU_MACRO_WRP/INST_XBCPU_MACRO/inst_cpu_shell_vdd_wrapper/inst_cpu_shell/ia_subsys/bia/ssa_par/grp_ssa/ssa_core_top/ssa_core/bunit/bconfig/bmbound\[31:0\] 0/vobs/eagle2-xg746-prj/test/src/host/xian/pac_chip/pac_tick_dly_common