Python 读取txt内容写入xlsx格式的excel中

import openpyxl
import codecs
import openpyxl.utils import get_column_letter
def txt_to_xlsx(filename,outfile):
    fr=codecs.open(filename,'r')
    wb=openpyxl.Workbook()
    #workbook： 工作簿，一个excel文件包含多个sheet。
    ws=wb.active
    ws=wb.create_sheet()
    #sheet：工作表，一个workbook有多个，表名识别如“sheet1”,“sheet2”等。
    ws.title='Sheet1'
    row=0
    for line in fr:
        row+=1
        line=line.strip()
        # strip() 方法用于移除字符串头尾指定的字符（默认为空格或换行符）或字符序列。
        line=line.spilt('\t')
        col=0
        for j in range(len(line)):
          col+=1
          ws.cell(colum=col,row=row,value=line[j].format(get_column_letter(col)))
    wb.save(outfile)
  #读取xlsx内容
def read_xlsx(filename):
    wb=openpyxl.load_workbook(filename)
    ws=wb.get_sheet_by_name('Sheet1')
    for row in ws.rows:
        for cell in row:
            print(cell.value)
    for col in ws.columns:
        for cell in col:
            print(cell.value)
if __name__=='__main__':
    inputfileTxt=''
    outfileExcel=''
    txt_to_xlsx(inputfileTxt,outfileExcel)
    read_xlsx(outfileExcel)
    

python 获取一大段文本之间两个关键字之间的内容

import re
class match2Words(object):
lines=0    
    def __init__(self,path,word1,word2):
        self.path = path
        self.word1 = word1
        self.word2 = word2
    def key_match(self):
    with open(self.path,'rb') as f:
            buffer = f.read()
            pattern = re.compile(self.word1+b'(.*?)'+self.word2,re.S)
            result = pattern.findall(buffer)
            if result != []:
                print(result) 
                #self.lines +=1
                #print("匹配到的行数：",self.lines) 
             else:
                print("没有找到你输入的关键字")
                path = input("F:/log.lammps")
word1 = "Step Temp TotEng PotEng KinEng Pxx Pyy Pzz Lx Ly Lz v_sxx v_syy v_szz v_sxyxy v_sxzxz v_szyzy"
word2 = b"end"
matchWords = match2Words(path, word1,word2)
matchWords.key_match()