Python小工具—txt转excel和word

07-17 1383阅读

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()
  
Python小工具—txt转excel和word
(图片来源网络,侵删)
VPS购买请点击我

文章版权声明:除非注明,否则均为主机测评原创文章,转载或复制请以超链接形式并注明出处。

目录[+]