1.txt转excel

import openpyxl  # 创建一个新的Excel工作簿 wb = openpyxl.Workbook() sheet = wb.active  # 题干和答案的标题 sheet['A1'] = '题干' sheet['B1'] = '答案'  # 打开txt文件并读取内容 with open('xiti.txt', 'r', encoding='utf-8') as file:     lines = file.readlines()  # 初始变量 current_question = [] current_answer = '' row = 2  # 从第二行开始写入数据  # 遍历文件内容 for line in lines:     line = line.strip()  # 去除每行的两端空白字符     if line.startswith('答案'):         # 遇到答案关键字，保存当前题干         if current_question:             question_text = '\n'.join(current_question)             sheet.cell(row=row, column=1).value = question_text             # 保存当前答案，并重置current_answer             sheet.cell(row=row, column=2).value = current_answer             row += 1         # 保存答案文本，并重置current_question         current_answer = line[len('答案'):].strip()