win32com - win32com으로 event처리

# -*- coding: utf-8 -*-

import time #내장모듈

import pythoncom #pywin32 의 모듈

import win32com.client as win32 #pywin32 의 모듈



xlapp = win32.dynamic.Dispatch('Excel.Application')

workbook = xlapp.ActiveWorkbook

sheet = workbook.ActiveSheet

class SheetEvents:

    def OnChange(self, range_obj):

       print("old 셀주소 => ", range_obj.Address)

       print("값이 변경된 o1d 의 셀값 => ", range_obj.Value)

    def OnDeactivate(self):

       print("pcell 안의 메소드 실행 =>")

    def OnSelectionChange(self, range_obj):

       range_obj.Value = range_obj.Address

       print("선택한 영역이 바뀐것 => ", range_obj.Value)

if __name__ == "__main__":



    excel_sheet_event = win32.WithEvents(sheet, SheetEvents)

    while True:

       pythoncom.PumpWaitingMessages()

# -*- coding: utf-8 -*-

import pcell

import time #내장모듈

import pythoncom #pywin32 의 모듈

import win32com.client as win32 #pywin32 의 모듈



excel = pcell.pcell()

class SheetEvents:

    def OnChange(self, rng):

       print("old 셀주소 => ", rng.Address)

       print("값이 변경된 o1d 의 셀값 => ", rng.Value)

    def OnDeactivate(self):

       print("pcell 안의 메소드 실행 =>", excel.read_address_in_activecell())

    def OnSelectionChange(self, range_obj):

       print("선택한 영역이 바뀐것 => ", range_obj.Value)

       print("pcell 안의 메소드 실행 =>", excel.read_address_in_activecell())

       excel.paint_cell("", excel.read_address_in_activecell(), "b1u88")

if __name__ == "__main__":

    excel = pcell.pcell()

    #excel_application_ event - win32.WithEvents(exce1, ApplicationEvents)

    #excel_workbook_event = win32.WithEvents(excel.active_workbook(), WorkbookEvents)

    excel_sheet_event = win32.WithEvents(excel.get_activesheet_object(), SheetEvents)

    while True:

       pythoncom.PumpWaitingMessages()