python 读写excel

import xlrd
import xlwt
from xlutils.copy import copy

# 打开excel文件获取数据
data = xlrd.open_workbook('E:/test.xls')
# 获取一个工作表
table = data.sheets()[0]  # 通过索引顺序获取
# table = data.sheet_by_index(0)  # 通过索引顺序获取
# table = data.sheet_by_name(u'sheet1')  # 通过名称获取
# 获取整行的数据
p = table.row_values(0)
# 获取整列的数据
q = table.col_values(0)
# 获取行数
nrows = table.nrows
# 获取列数
ncols = table.ncols
# 获取单元格数据
cell = table.cell(0, 0).value
# 使用行列索引
cell_1 = table.row(0)[1].value
cell_2 = table.col(0)[1].value

"""xlwt"""
# 创建工作簿和工作表
workbook = xlwt.Workbook()
sheet = workbook.add_sheet('sheet1', cell_overwrite_ok=True)  # cell_overwrite_ok=Ture可以解决对一个单元格重复操作报Exception: Attempt to overwrite cell的错误
sheet.write(0, 0, 'haha')
sheet.write(0, 0, 'hehe')
workbook.save('e:/test.xls')

"""xlutils"""
rb = xlrd.open_workbook('E:/test.xls')
wb = copy(rb)
ws = wb.get_sheet(0)
ws.write(0, 0, 'changed')
wb.save('E:/test.xls')