python用win32com处理excel表格

太阳不下山

　　今天一同事让处理一个excel，把一个excel里固定位置的内容读取写到另一个excel中的固定位置里，查了一些资料，python有好多处理excel的模块，对比之后感觉用win32com来处理这个问题比较简单，其中包含了处理文件路径和文件名字为中文的编码问题，下面是自己写的代码：

#!/usr/bin/env python # -- coding: utf-8 --  from win32com.client import constants,Dispatch import os,sys,datetime,time,shutil  class rw_excel:    def __init__(self):     self.yesterday = (datetime.date.today() - datetime.timedelta(days=2)).strftime('%Y%m%d')     self.cwd = os.getcwd()    def read_excel(self):     try:       f = self.cwd + "\" + self.yesterday + "\" + u"汇总".encode("gbk") + "_" + self.yesterday + ".xlsx"       print f       f_open = (f)       xlsApp = Dispatch("Excel.Application")       xlsApp.Visible = False       xlsBook = xlsApp.Workbooks.Open(f_open)       sheet_name = ('统计').decode("utf8")       xlsSht = xlsBook.Worksheets(sheet_name)       R = []       open = [[2,2],[3,2],[4,2],[5,2],[6,2],[7,2],[8,2],[9,2],[10,2],[11,2],[12,2],[13,2],[14,2],[15,2]]       for i in open:         a = xlsSht.Cells(i[0],i[1]).Value.encode("utf8")         R.append(a)       return R     except Exception,e:       print e    def write_excel(self,R):     f = self.cwd + "\" + self.yesterday + "\" + u"数量汇总".encode("gbk") + "(GY)_" + self.yesterday + ".xls"     print f     f_save = (f)     xlsApp = Dispatch("Excel.Application")      xlsApp.Visible = False     xlsBook = xlsApp.Workbooks.Open(f_save)     sheet_name = ('数量汇总(GY)').decode("utf8")     xlsSht = xlsBook.Worksheets(sheet_name)     save = [[2,5],[3,5],[6,5],[7,5],[9,5],[10,5],[12,5],[13,5],[14,5],[17,5],[18,5],[19,5],[20,5],[23,5]]     for i in range(len(R)):       xlsSht.Cells(save[i][0],save[i][1]).Value = R[i]     xlsBook.Close(SaveChanges=1)     xlsApp.Quit()    def main(self):     R = self.read_excel()     print "read_excel OK"     self.write_excel(R)     print "write_excel GY OK"     print "Excel OK"  class move:    def __init__(self):     self.yesterday = (datetime.date.today() - datetime.timedelta(days=2)).strftime('%Y%m%d')     self.cwd = os.getcwd()    def copy(self,src, dst):     if os.path.isdir(src):       base = os.path.basename(src)       if os.path.exists(dst):         dst = os.path.join(dst, base)       if not os.path.exists(dst):         os.makedirs(dst)       names = os.listdir(src)       for name in names:         srcname = os.path.join(src, name)         self.copy(srcname, dst)     else:       shutil.copy2(src, dst)    def mk_dir(self):     a = self.cwd + "\" + u"处理名单_%s".encode("gbk") % self.yesterday + "\" + u"处理名单(GY)_%s".encode("gbk") % self.yesterday     print a     if not os.path.isdir(a):       os.makedirs(a)     b = self.cwd + "\" + u"处理名单_%s".encode("gbk") % self.yesterday + "\" + u"处理名单(CS)_%s".encode("gbk") % self.yesterday     print b     if not os.path.isdir(b):       os.makedirs(b)     f = self.cwd + "\" + self.yesterday + "\"     names = os.listdir(f)     for name in names:       if "txt" in name or "CS" in name:         self.copy(os.path.join(f,name),os.path.join(b,name))       else:         self.copy(os.path.join(f,name),os.path.join(a,name))     shutil.rmtree(f)     print "Move ok"    def main(self):     self.mk_dir()  if __name__=="__main__":   boss = rw_excel()   boss.main()   boss = move()   boss.main() 以下是运行打印的结果：