读写excel文件

一、使用xlwt、pandas进行excel文件读写，高版本python不支持xlrd读操作

二、实例：

import xlwt
import pandas
rbook = pandas.read_excel("student_score.xlsx")
rbook["总分"] = ""
res = rbook.values
print(res)
print(rbook.columns, len(rbook.columns))


wbook = xlwt.Workbook()
wsheet = wbook.add_sheet("学生成绩")
for x in range(len(rbook.columns)):
    wsheet.write(0, x, rbook.columns[x])

for i in range(0, len(res)):
    for j in range(len(rbook.columns)):
        if j == len(rbook.columns) - 1:
            t = sum(res[i][1:4])
            wsheet.write(i + 1, j, t)
        else:
            wsheet.write(i+1, j, res[i][j])


wbook.save("test.xlsx")