COM操作excel

#========================================================#              2012/07/31 23:18:22                  #========================================================from win32com.client import Dispatchimport timeapi = 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 = chwork_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()