python3 50个练习例子之简单读写excel

1. 写一个excel

import xlwt
from random import randint
wbook = xlwt.Workbook()
wsheet = wbook.add_sheet('student')
headerName = ['姓名','语文','数学','外语']
x = ['张','李','王','宋','谢']

# 写一个学生成绩单的excel
for r in range(10):
    for c in range(len(headerName)):
        if r == 0:
            # write(r, c, label='', style=<xlwt.Style.XFStyle object at 0x00000000032E7860>)
            wsheet.write(r,c,label=headerName[c]) # 第一行表头
        else:
            if c == 0:
                wsheet.write(r,c,label=x[randint(0,4)] + str(r)) # 第一列姓名
            else:
                wsheet.write(r,c,label=randint(60,100)) # 其余列成绩

wbook.save('student.xlsx') # 保存Excel

2. 读写excel

import xlwt,xlrd

# 读取学生成绩单，并加一列总分，计算总分值
book = xlrd.open_workbook('student.xlsx