python使用xlrd xlwt操作Excel

这里主要示范模块的一些简单实用方法，方便以后查阅：

import xlrd
import xlwt
import sys



"""下面是xlrd模块的一些简单实用方法"""
fileName = "testFile.xlsx"
fd = xlrd.open_workbook(fileName)

try:
    sheetPage = fd.sheet_by_name(u"Sheet1")
except:
    print "no sheet named Sheet1 in %s " % filename 
    
rows = sheetPage.nrows
cols = sheetPage.ncols
print "Sheet1 rows: " + str(rows)
print "Sheet1 cols: " + str(cols)


"""下面是xlwt模块的一些简单实用方法"""

"""用来存储用户输入的name age"""
name_age_list = []

""" 初始化输入计数 """
redNum = 0


"""循环读取"""
while True:
    if redNum == 6:
        break
    else:
        line = sys.stdin.readline()
        redNum += 1
        name_age_list.append(line)

"""新建文件"""
sheetFile = xlwt.Workbook()
"""建立页表"""
sheetPage = sheetFile.add_sheet("nameSheet")

i = 0    
for red in name_age_list:
    name = red.split()[0]
    age = red.split()[1]
    sheetPage.write(i, 0, name)
    sheetPage.write(i, 1, int(age))
    i += 1
    
"""保存文件"""
sheetFile.save("example1.xls")