oiHddlZddlZddlmZddlmZmZmZejdddddejd dd ddej d dddd gGd dZ GddZ dZ dZ edkrFddlZejje dejvr e e dSe e dSdS)N) universal)DispatchWithEvents constantsgencachez&{00020813-0000-0000-C000-000000000046}T) bForDemandz&{2DF8D04C-5BFA-101B-BDE5-00AA0044DE52}z&{AC0714F2-3D04-11D1-AE7D-00A0C90F26F4}_IDTExtensibility2ceZdZdZdS) ButtonEventcNddl}ddl}|dd|j|S)NrzHello from Pythonz Python Test)win32conwin32ui MessageBox MB_OKCANCEL)selfbuttoncancelrrs IC:\PYTHON\Scheduler\python\Lib\site-packages\win32com/demos/excelAddin.pyOnClickzButtonEvent.OnClickFs5. x?STTT N)__name__ __module__ __qualname__rrrr r Es#rr cVeZdZdgZgZejZdZdZ dZ dZ dZ dZ dZd Zd Zd S) ExcelAddinr z&{C5482ECA-F559-45A0-B078-B2036E6F011A}zPython.Test.ExcelAddinz)win32com.server.policy.EventHandlerPolicycd|_dS)N) appHostApp)rs r__init__zExcelAddin.__init__Vs rctd|||| ||_|jjdtjtjd}|jtjd}t|tx}|_ tj |_ d|_d|_d|_d |_d|_dS#t&j$r}|j\}} } } td || fz| td nC| \} } }}}}td | td |td||fzYd}~dSYd}~dSd}~wwxYw)N OnConnection PythonBarT)NamePositionMenuBar Temporary Greetings)Type Parameterz&PythonzPython rules the World34z&The Excel call failed with code %d: %sz&There is no extended error informationzThe source of the error iszThe error message isz$More info can be found in %s (id=%d))printr CommandBarsAddr msoBarTopmsoBarTypeNormalControlsmsoControlButtonrr toolbarButtonmsoButtonCaptionStyle BeginGroupCaption TooltipTextWidthVisible pythoncom com_errorargs)r application connectModeaddincustomcbcMyBar btnMyButtonxxx_todo_changemehrmsgexcargwcodesourcetexthelpFilehelpIdscodes rr#zExcelAddin.OnConnectionYs nk;vFFF S)DO266 ",!2 7H #+///;0K0B[00 K$,!* :K %)K ""+K &>K # $K #H   " S S S"3"8 Rc3 :b#YF G G G{>?????B<vtXvu2F;;;,d333<&?QQRRRRRRRRR @????? SsB4C EA/EEcptd|jdjd|_dS)NOnDisconnectionr$)r-r r.Delete)rmoderBs rrQzExcelAddin.OnDisconnectionzs5     ##K0077rc&td|dS)NOnAddInsUpdater-rrBs rrUzExcelAddin.OnAddInsUpdates '''''rc&td|dS)NOnStartupCompleterVrWs rrYzExcelAddin.OnStartupCompletes !6*****rc&td|dS)NOnBeginShutdownrVrWs rr[zExcelAddin.OnBeginShutdowns (((((rN)rrr_com_interfaces__public_methods_r<CLSCTX_INPROC_SERVER _reg_clsctx_ _reg_clsid_ _reg_progid__reg_policy_spec_r!r#rQrUrYr[rrrrrNs,-1L:K+LCSSSB (((+++)))))rrcjddl}||jd}|||j}||dd|jd||dd|jd||dd|jd||dd|jd dS) Nrz&Software\Microsoft\Office\Excel\AddinsCommandLineSafe LoadBehaviorr Descriptionz Excel Addin FriendlyNamezA Simple Excel Addin)winreg CreateKeyHKEY_CURRENT_USERra SetValueEx REG_DWORDREG_SZ)klassrhkeysubkeys r RegisterAddinrqsMMM    "N  C  c5#5 6 6F f/F4DaHHH fna1A1EEE fmQ }MMM fna@VWWWWWrcxddl} ||jd|jzdS#t$rYdSwxYw)Nrz'Software\Microsoft\Office\Excel\Addins\)rh DeleteKeyrjraOSError)rnrhs rUnregisterAddinrusgMMM   $ :U=O O           s #+ 99__main__z --unregister)sysr<win32comrwin32com.clientrrr EnsureModuleRegisterInterfacesr rrqrurwin32com.server.registerserverregisterUseCommandLineargvrrrrsb CCCCCCCCCC,aA$,aA$  ,aA8L7M 8)8)8)8)8)8)8)8)v X X X     z#### O++J777!! ##### j!!!!!r