Python COM and Excel

[nphankey]

I'm struggling to tame Excel using Python and COM.

Most of the following code is working except for the setting of the activesheet.

Also, I would like to know how to release a COM object without closing the application / dispatcher that launched excel?

class ExcelCom32(object):
    """
    Access Excel using python via COM.
    """
    def __init__(self, visible=False):
        self.app = Dispatch("Excel.Application")
        #self.app.Visible = 0
        self.sheet = 1
 
    def openBook(self, filename):
        """
        Open an existing Excel workbook.
        """
        # Set the path to the current working directory and add the path to the TxDatabase
        MyPath = os.getcwd() + r'\TxDatabase'        
 
        self.app.Workbooks.Open(MyPath + '\\' + filename)
 
    def setActiveSheet(self, sheet):
        """
        Set the active worksheet.
        """
        self.ActiveSheet = sheet
 
    def getRange(self, range):
        """
        Get a range object for the specified range or single cell.
        """
        return self.app.ActiveWorkbook.Sheets(self.sheet).Range(range)
 
    def getValue(self, x, y):
        """
        Get the value of a 'cell' using Cells(x, y).
        """
        value = self.app.ActiveSheet.Cells(y, x).Value
        return value
 
    def setVisible(self, v):
        """
        Set the Excel Application to Visible
        """
        self.app.Visible = v
 
    def setValue(self, v, x, y):
        """
        Get the value of a 'cell' using Cells(x, y).
        """
        self.app.ActiveSheet.Cells(y, x).Value = v
 
    def closeBook(self):
        """
        Close the active workbook.
        """
        self.app.ActiveWorkbook.Close()
 
    def quit(self):
        """
        Quit Excel.
        """
        return self.app.Quit()
 
    def findColEnd(self, x, y):
        """
        Find the last value in the spreadsheet and set the end point
        """
        c = 0
        for yy in range(y, 1000):
            value = self.app.ActiveSheet.Cells(yy, x).Value
            if value == None:
                break
            c = c + 1
        return c + y
 
    def findRowEnd(self, x, y):
        """
        Find the last value in the spreadsheet and set the end point
        """
        c = 0
        for xx in range(x, 1000):
            value = self.app.ActiveSheet.Cells(y, xx).Value
            if value == None:
                break
            c = c + 1
        return c + x