37,721
社区成员
发帖
与我相关
我的任务
分享
#========================================================
# 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')
for i in m_range:
print i
work_book.Close()
except Exception,e:
print e
work_book.Save()
work_book.Close()