简单python读取excel操作

#导入需要用到的模块
import xlrd
import xlwt
from xlutils.copy import copy


filename = "E://test1.xls"

#读取单张表格的所有内容
def ReadSheet(sheet):
  for row in range(sheet.nrows):
      for col in range(sheet.ncols):
          print("sheet[%d][%d]:%s"%(row, col, sheet.cell(row, col).value))
  return

#修改表格内容
def WriteSheet(book):
  rb = copy(book)
  for each_sheet in book:
      sheetIdx = 0
      wb = rb.get_sheet(sheetIdx)
      sheetIdx += 1
      for row in range(each_sheet.nrows):
          #for col in range(each_sheet.ncols):
              wb.write(row, each_sheet.ncols, 'add change')
      rb.save(filename)
  return


#打开excel文件
book = xlrd.open_workbook(filename)

#遍历execl中所有表格并读取所有内容
for eachsheet in book:
    ReadSheet(eachsheet)

#修改表格内容
WriteSheet(book)

#遍历execl中所有表格并读取所有内容
for eachsheet in book:
    ReadSheet(eachsheet)