读，写，修改excel

import xlwt
写excel:
book  = xlwt.Workbook()
sheet = book.add_sheet('sheet1')

data = [
    ["1","小花",99,100,98.5],
   ["2","小王",90,30.5,95],
   ["3","小明",67.5,49.6,88]
]
title = ['编号','姓名','语文成绩','数学成绩','英语成绩','总分','平均分']
row = 0
for t in title:          #处理表头
    sheet.write(0,row,t )#第一行
    row+=1

row = 1
for v in data:           #循环行
    col = 0
    sum_score = sum(v[2:])
    arg_score = round(sum_score/3,2)
    v.append(sum_score)
    v.append(arg_score)
    for value in v:     #循环列
        sheet.write(row,col,value)
        col+=1
    row+=1

book.save('students.xls') #如果用wps的话,可以用xslx

读excel:
import xlrd
xlrd.open_workbook('students.xls')    #打开一个表
sheet = book.sheet_by_index(0)        #根据下标来取
# sheet = book.sheet_by_name('sheet1')#根据名字来取
sheet.cell(0,0).value                 #取指定单元格内容 0行0列
sheet.row_value(1)                    #取某一行的数据
sheet.row_value(1)       #取某一行的数据
sheet.col_value(1)       #取某一列的数据
sheet.nrows              #取多少行
sheet.ncols              #取多少列

修改excel:

from xlutils import copy
import xlrd
import os

book = xlrd.open_workbook('students.xls')
#xlrd模块不能直接做修改，只能读,需要用到xlutils模块
new_book = copy.copy(book)
sheet = new_book.get_sheet(0)  #copy过来的，不是在xlrd里面，所以要用get方法获取
sheet.write(0,0,"id")
sheet.write(0,1,"name")
os.rename('students.xls','students_bak.xls')
new_book.save('students.xls')