1
2

import xlrd # 读取excel库：xlrd
import xlwt # 读取excel库：xlwt

1
2
3
4

book = xlrd.open_workbook('input.xls')
# 使用xlrd中的open_workbook方法打开input.xls
sheet1 = book.sheet_by_index(0)
# workbook对象的sheet_by_index方法打开第一个工作表，注意这里的索引值是从0开始的

1
2

row_1 = sheet1.row(1).value # 读取第二行
pos_1_0  =sheet1.row(1)[0].value # 读取第二行的第一个单元格

1
2

col_1 = sheet1.col(1).value # 读取第二列
pos_0_1  =sheet1.col(1)[0].value # 读取第二列的第一个单元格

1

pos_1_0 = sheet1.cell(1, 0).value # 读取第二行的第一个单元格

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19

import xlrd
# 打开excel文件
sheet1 = xlrd.open_workbook('123.xls').sheet_by_index(0)
# 打开txt文件
output = open('output.txt', 'w', encoding='utf-8')

for i in range(1, sheet1.nrows):
    if sheet1.row(i)[0].value in [1, 2]:
        output.write(f'{sheet1.row(i)[1].value}:{sheet1.row(i)[2].value}\n')
        output.write(f'答案：{str(sheet1.row(i)[3].value)}\n')
        output.write(f'A: {sheet1.row(i)[4].value}\n')
        output.write(f'B: {sheet1.row(i)[5].value}\n')
        output.write(f'C: {sheet1.row(i)[6].value}\n')
        output.write(f'D: {sheet1.row(i)[7].value}\n')
        output.write(f'E: {sheet1.row(i)[8].value}\n')
    if sheet1.row(i)[0].value == 3:
        output.write(f'{sheet1.row(i)[1].value}:{sheet1.row(i)[2].value}\n')
        output.write(f'答案：{str(sheet1.row(i)[3].value)}\n')
output.close()