Simple Microsoft Excel controller with win32com.client

ExcelControl.py

import win32com.client, win32ui

class ExcelControl:
    def __init__(self):
        # Initialize Excel app
        self.excel = win32com.client.Dispatch("Excel.Application")
        self.excel.Visible=True

    def Openfile(self):
        # open file
        self.dlg = win32ui.CreateFileDialog(1) # 1 : Open File dialog box
        self.dlg.DoModal()

        self.filename = self.dlg.GetPathName()
        print(self.filename)

        if self.filename != None:
            self.wb = self.excel.Workbooks.Open(self.filename)
            self.ws = self.wb.ActiveSheet # Not necessarily active sheet
        else:
            self.wb = self.excel.Workbooks.Add()
            self.ws = self.wb.Worksheets("Sheet1")

    def SetCellValue(self,row_index, col_index,value):
        # set value at specific cell position
        self.ws.Cells(row_index,col_index).Value = value

    def UndoLast(self):
        pass # to be implemented
        # self.excel.Undo()