COM操作excel

#========================================================
#              2012/07/31 23:18:22                  
#========================================================
from win32com.client import Dispatch
import time
api = Dispatch('Excel.Application')
work_book = api.Workbooks.Open(r'C:\Users\ago\Desktop\test.xls')
try:
    work_sheet = work_book.Worksheets
    '''
    #创建单元格内容
    for i in range(1,27):
        for j in range(1,27):
            ch = 65 + j -1
            ch = chr(ch) + str(i)
            work_sheet(1).Cells(i,j).Value = ch
			work_book.Save()
    '''
    m_range = work_sheet(1).Range('A1:Z26').Find('B15')#查找单元格内容为'B15'的range
    for i in m_range:
        print i #输出单元格内容为'B15'的Cell
    
    work_book.Close()
except Exception,e:
    print e
    work_book.Save()
    work_book.Close()