求大佬帮忙看看有什么问题，一直报告超出范围

Question

from openpyxl import load_workbook, Workbook
import random
wb = load_workbook('选手信息.xlsx')
sheetname=wb.sheetnames[0]
ws=wb[sheetname]
dic= {}
for rn in range(1, ws.max_row + 1):
temp_list =[]
key=ws['A'+str(rn)].value
w1 =ws['B'+str(rn)].value
w2 =ws['C'+str(rn)].value
w3 =ws['D'+str(rn)].value
temp_list =[w1, w2, w3]
dic[key] = temp_list
nums_list = []
result_list = []
aver_list = []
scor_list = []
rows = 8
columns = 10
for i in range(rows):
nums_list.append([])
result_list.append([])
for j in range(columns):
num = random.randint(0,10)
nums_list[i].append(num)
nums_list[i].sort()
del nums_list[i][0]
del nums_list[i][-1]
aver = sum(nums_list[i]) / len(nums_list[i])
scor = round(aver * dic['s0' + str(i + 1)][2], 3)
result_list[i].append('s0' + str(i + 1))
for n in range(3):
result_list[i].append(dic['s0' + str(i + 1)][n])
last_result=sorted(result_list,key=lambda e:e[5],reverse=True)
for n in range(rows):
last_result[n].append(n+1)
print(last_result)
wb=Workbook()
sheet = wb.active
sheet.title='成绩表'
sheet_field=['选手ID','姓名','国家',
'难度系数','平均分','最后得分','名次'
]
sheet.append(sheet_field)
for s in last_result:
sheet.append(s)
wb.save('result_final.xlsx')

Answer 1

result_list列表里边有元素的长度不够，建议你把result_list打印输出一下，看看具体是原因！