phython - Excel

from win32com.client import Dispatch, constants
import os

class Utility(object):

    @staticmethod
    def xlSmartOpen(app, filePath, fileName):
        wbRet = None
        for wb in app.Workbooks:
            if wb.Name == fileName:
                wbRet = wb
                break
        else:
            if filePath=='': # mean that I am opening Result File
                if os.path.exists(fileName):wbRet = app.Workbooks.Open(fileName)
                else:
                    wbRet=app.Workbooks.Add()
                    wbRet.SaveAs(fileName)
            else:
                wbRet = app.Workbooks.Open(filePath+fileName)
        return wbRet
        

class ManipExcelFiles(object):
    def __init__(self, folder, xlSim , xlResult):
        # Next implement that if file name = * we should take all the files in folder
        self.excel = Dispatch("Excel.Application")
        self.excel.Visible = False
        # I open Result File
        self.resultWb = Utility.xlSmartOpen(self.excel, '', xlResult)

        # I loop over input file
        if xlSim=='*.xls':
            dirList=os.listdir(folder)
        else:
            dirList = [xlSim]
        ColumnIndic = 1            
        for filename in dirList:
            self.InputFileWb = Utility.xlSmartOpen(self.excel, folder, filename)
            self.InputFileWs = self.InputFileWb.Worksheets('Inputs and results')
            self.InputFileWs.Activate()
            self.InputFileWs.Cells(1,1).Select()
            self.InputFileWs.Range(self.InputFileWs.Cells(1,1),self.InputFileWs.Cells(1547,6)).Select()
            self.excel.Selection.Copy()
            self.resultWb.Worksheets[0].Activate()
            self.resultWb.Worksheets[0].Cells(1,ColumnIndic).Select()
            self.excel.Selection.PasteSpecial( Paste=constants.xlPasteValues)
            #self.excel.Selection.PasteSpecial( Paste=constants.xlPasteFormats)
            self.excel.CutCopyMode = False
            self.InputFileWb.Close(SaveChanges=False)
            ColumnIndic = ColumnIndic + 6
            
    def shut(self):
        self.excel.CutCopyMode = False
        self.resultWb.Close(SaveChanges=True)
        del self.excel
        
    
testfile = ManipExcelFiles('C:/essai/OUTPUT_1/','*.xls','C:/Essai/PlanPension.xls')
testfile.shut()