python进行简单表格运算

import xlrd
import xlwt

xlsx = xlrd.open_workbook(‘11.xls’)
sheet = xlsx.sheet_by_index(0)
all_data = []
num_set = set()
for row_i in range(1,sheet.nrows):
num = sheet.cell_value(row_i,0)
name = sheet.cell_value(row_i,1)
grade = sheet.cell_value(row_i,3)

student = {
    'num':num,
    'name':name,
    'grade':grade,

}
all_data.append(student)
num_set.add(num)
sum_list = []
for num in num_set:
    name = ''
    sum = 0
    for student in all_data:
        if num == student['num']:
            sum += student['grade']
            name = student['name']
    sum_stu = {
        'num':num,
        'name':name,
        'sum':sum
    }
sum_list.append(sum_stu)
print(sum_list)
#新建工作簿
new_workbook = xlwt.Workbook()
#新建sheet
worksheet = new_workbook.add_sheet('1')
#写入第一列的内容
#新建单元格，并写入内容
worksheet.write(0,0,'学号')
worksheet.write(0, 1, '姓名')
worksheet.write(0, 2, '总分')
#自动写入后面的内容
for row in range(0,len(sum_list)):
    worksheet.write(row+1,0,sum_list[row]['num'])
    worksheet.write(row+1,1,sum_list[row]['name'])
    worksheet.write(row+1,2,sum_list[row]['sum'])
    #保存
new_workbook.save(‘总分.xls')