pip install xlrd

import xlrd

book = xlrd.open_workbook("myfile.xls") # 创建读取xls 对象

print("表格文件的sheet页有  {0}".format(book.nsheets))
print("表格文件的sheet页名: {0}".format(book.sheet_names()))
sh = book.sheet_by_index(0) # 选择第一页操作
print("{0} {1} {2}".format(sh.name, sh.nrows, sh.ncols))

for rx in range(sh.nrows): # 按行读取
    print(sh.row(rx))

for row in range(sh.nrows):  # 按单元格读取
    for col in ncols range(sh.ncols)
        print("单元格 内容  {0}".format(sh.cell_value(rowx=row, colx=col)))

from xlwt import Workbook

book = Workbook(encoding='utf-8') # 创建 Workbook 对象
sheet1 = book.add_sheet('Sheet 1') # 创建sheet页
book.add_sheet('Sheet 2')
sheet1.write(0,0,'A1') # 写入单元格
sheet1.write(0,1,'B1')
row1 = sheet1.row(1)
row1.write(0,'A2')
row1.write(1,'B2')

book.save('simple.xls') # 保存文件

pip install xlutils

from xlrd import open_workbook
from xlwt import easyxf
from xlutils.copy import copy
rb = open_workbook('source.xls',formatting_info=True)
rs = rb.sheet_by_index(0)
wb = copy(rb)
ws = wb.get_sheet(0)
plain = easyxf('')
for i,cell in enumerate(rs.col(2)):
 if not i:
 continue
 ws.write(i,2,cell.value,plain)
for i,cell in enumerate(rs.col(4)):
 if not i:
 continue
 ws.write(i,4,cell.value-1000)
wb.save('output.xls')