# 读取题库文件 with open('未命名.txt', 'rb') as f: encoding = chardet.detect(f.read())['encoding']
with open('未命名.txt', 'r', encoding=encoding) as f: lines = f.readlines()
# 将题目和选项分别存储到列表中 questions = [] options = [] for line in lines: elements = line.strip().split(' ') if len(elements) == 5: q, a, b, c, d = elements questions.append(q) options.append([a, b, c, d]) else: print(f'Error: invalid line: {line}')
# 将数据存储到Excel文件中 df = pd.DataFrame({'题目': questions, '选项A': [o[0] for o in options], '选项B': [o[1] for o in options], '选项C': [o[2] for o in options], '选项D': [o[3] for o in options]}) df.to_excel('question_bank.xlsx', index=False)