excel 统计数据

#读excel
import xlrd
from xlutils.copy import copy
bookData = xlrd.open_workbook('20230103.xlsx')
#copy数据
copyData = copy(bookData)
#选择第一个工作簿
sh = copyData.get_sheet(0)
print(f'{sh}--')


sh.write(5,0,'王八')
sh.write(5,1,'2班级')
sh.write(5,2,'80')


#统计数据

sh2 = copyData.add_sheet('统计数据')

count = 0
#选择第一个工作簿
rs = bookData.sheet_by_index(0)
print(rs)
#获取第一个工作簿的总行数
print(rs.nrows)
sum = 0
for i in range(1,rs.nrows):
    print(f'{i}--{rs.cell_value(i,2)}')
    num = rs.cell_value(i,2)
    print(type(int(num)))
    sum += int(num)
    print(sum)


sh2.write(0,0,'统计分数')
sh2.write(1,0,sum)
copyData.save('202301032239.xlsx')