如何使用VBA从Excel中的条件格式获取背景颜色(How to get the background color from a Conditional Formatting in Excel using VBA)

 像这样？ 这隐含地将一个装饰器添加到你的方法中（如果你愿意的话，你也可以基于此做一个明确的装饰器）： 
 
class Foo(object):
    def __getattribute__(self,name):
        attr = object.__getattribute__(self, name)
        if hasattr(attr, '__call__'):
            def newfunc(*args, **kwargs):
                print('before calling %s' %attr.__name__)
                result = attr(*args, **kwargs)
                print('done calling %s' %attr.__name__)
                return result
            return newfunc
        else:
            return attr
 
 当你现在尝试像这样的东西： 
 
class Bar(Foo):
    def myFunc(self, data):
        print("myFunc: %s"% data)

bar = Bar()
bar.myFunc(5)
 
 你会得到： 
 
before calling myFunc
myFunc:  5
done calling myFunc

Something like this? This implictly adds a decorator to your method (you can also make an explicit decorator based on this if you prefer that):
 
class Foo(object):
    def __getattribute__(self,name):
        attr = object.__getattribute__(self, name)
        if hasattr(attr, '__call__'):
            def newfunc(*args, **kwargs):
                print('before calling %s' %attr.__name__)
                result = attr(*args, **kwargs)
                print('done calling %s' %attr.__name__)
                return result
            return newfunc
        else:
            return attr
 
when you now try something like:
 
class Bar(Foo):
    def myFunc(self, data):
        print("myFunc: %s"% data)

bar = Bar()
bar.myFunc(5)
 
You'll get:
 
before calling myFunc
myFunc:  5
done calling myFunc