OpenPyXL 3.0.7
  • 教程
  • 简单用法
  • 性能
  • 优化模式
  • 插入和删除行和列,移动单元格范围
  • 操纵 Pandas 和 NumPy
  • 图表
  • 注释
  • 操控样式
  • 额外工作表特性
  • 条件格式化
  • 数据透视表
  • 打印设置
  • 使用过滤器和排序
  • 验证单元格
  • 定义名称
  • 工作表表格
  • 剖析公式
  • 日期和时间
  • 保护
  • 开发
  • openpyxl 包
  • 3.0.7 (2021-03-09)
  • 3.0.6 (2021-01-14)
  • 3.0.5 (2020-08-21)
  • 3.0.4 (2020-06-24)
  • 3.0.3 (2020-01-20)
  • 3.0.2 (2019-11-25)
  • 3.0.1 (2019-11-14)
  • 3.0.0 (2019-09-25)
  • 2.6.4 (2019-09-25)
  • 2.6.3 (2019-08-19)
  • 2.6.2 (2019-03-29)
  • 2.6.1 (2019-03-04)
  • 2.6.0 (2019-02-06)
  • 2.6.-b1 (2019-01-08)
  • 2.6-a1 (2018-11-21)
  • 2.5.14 (2019-01-23)
  • 2.5.13 (brown bag)
  • 2.5.12 (2018-11-29)
  • 2.5.11 (2018-11-21)
  • 2.5.10 (2018-11-13)
  • 2.5.9 (2018-10-19)
  • 2.5.8 (2018-09-25)
  • 2.5.7 (2018-09-13)
  • 2.5.6 (2018-08-30)
  • 2.5.5 (2018-08-04)
  • 2.5.4 (2018-06-07)
  • 2.5.3 (2018-04-18)
  • 2.5.2 (2018-04-06)
  • 2.5.1 (2018-03-12)
  • 2.5.0 (2018-01-24)
  • 2.5.0-b2 (2018-01-19)
  • 2.5.0-b1 (2017-10-19)
  • 2.5.0-a3 (2017-08-14)
  • 2.5.0-a2 (2017-06-25)
  • 2.5.0-a1 (2017-05-30)
  • 2.4.11 (2018-01-24)
  • 2.4.10 (2018-01-19)
  • 2.4.9 (2017-10-19)
  • 2.4.8 (2017-05-30)
  • 2.4.7 (2017-04-24)
  • 2.4.6 (2017-04-14)
  • 2.4.5 (2017-03-07)
  • 2.4.4 (2017-02-23)
  • 2.4.3 (未发行)
  • 2.4.2 (2017-01-31)
  • 2.4.1 (2016-11-23)
  • 2.4.0 (2016-09-15)
  • 2.4.0-b1 (2016-06-08)
  • 2.4.0-a1 (2016-04-11)
  • 2.3.5 (2016-04-11)
  • 2.3.4 (2016-03-16)
  • 2.3.3 (2016-01-18)
  • 2.3.2 (2015-12-07)
  • 2.3.1 (2015-11-20)
  • 2.3.0 (2015-10-20)
  • 2.3.0-b2 (2015-09-04)
  • 2.3.0-b1 (2015-06-29)
  • 2.2.6 (未发行)
  • 2.2.5 (2015-06-29)
  • 2.2.4 (2015-06-17)
  • 2.2.3 (2015-05-26)
  • 2.2.2 (2015-04-28)
  • 2.2.1 (2015-03-31)
  • 2.2.0 (2015-03-11)
  • 2.2.0-b1 (2015-02-18)
  • 2.1.5 (2015-02-18)
  • 2.1.4 (2014-12-16)
  • 2.1.3 (2014-12-09)
  • 2.1.2 (2014-10-23)
  • 2.1.1 (2014-10-08)
  • 2.1.0 (2014-09-21)
  • 2.0.5 (2014-08-08)
  • 2.0.4 (2014-06-25)
  • 2.0.3 (2014-05-22)
  • 2.0.2 (2014-05-13)
  • 2.0.1 (2014-05-13) brown bag
  • 2.0.0 (2014-05-13) brown bag
  • 1.8.6 (2014-05-05)
  • 1.8.5 (2014-03-25)
  • 1.8.4 (2014-02-25)
  • 1.8.3 (2014-02-09)
  • 1.8.2 (2014-01-17)
  • 1.8.1 (2014-01-14)
  • 1.8.0 (2014-01-08)
  • 1.7.0 (2013-10-31)
  • Source code for abc

    # Copyright 2007 Google, Inc. All Rights Reserved.
    # Licensed to PSF under a Contributor Agreement.
    """Abstract Base Classes (ABCs) according to PEP 3119."""
    def abstractmethod(funcobj):
        """A decorator indicating abstract methods.
        Requires that the metaclass is ABCMeta or derived from it.  A
        class that has a metaclass derived from ABCMeta cannot be
        instantiated unless all of its abstract methods are overridden.
        The abstract methods can be called using any of the normal
        'super' call mechanisms.
        Usage:
            class C(metaclass=ABCMeta):
                @abstractmethod
                def my_abstract_method(self, ...):
                    ...
        """
        funcobj.__isabstractmethod__ = True
        return funcobj
    class abstractclassmethod(classmethod):
        """A decorator indicating abstract classmethods.
        Similar to abstractmethod.
        Usage:
            class C(metaclass=ABCMeta):
                @abstractclassmethod
                def my_abstract_classmethod(cls, ...):
                    ...
        'abstractclassmethod' is deprecated. Use 'classmethod' with
        'abstractmethod' instead.
        """
        __isabstractmethod__ = True
        def __init__(self, callable):
            callable.__isabstractmethod__ = True
            super().__init__(callable)
    class abstractstaticmethod(staticmethod):
        """A decorator indicating abstract staticmethods.
        Similar to abstractmethod.
        Usage:
            class C(metaclass=ABCMeta):
                @abstractstaticmethod
                def my_abstract_staticmethod(...):
                    ...
        'abstractstaticmethod' is deprecated. Use 'staticmethod' with
        'abstractmethod' instead.
        """
        __isabstractmethod__ = True
        def __init__(self, callable):
            callable.__isabstractmethod__ = True
            super().__init__(callable)
    class abstractproperty(property):
        """A decorator indicating abstract properties.
        Requires that the metaclass is ABCMeta or derived from it.  A
        class that has a metaclass derived from ABCMeta cannot be
        instantiated unless all of its abstract properties are overridden.
        The abstract properties can be called using any of the normal
        'super' call mechanisms.
        Usage:
            class C(metaclass=ABCMeta):
                @abstractproperty
                def my_abstract_property(self):
                    ...
        This defines a read-only property; you can also define a read-write
        abstract property using the 'long' form of property declaration:
            class C(metaclass=ABCMeta):
                def getx(self): ...
                def setx(self, value): ...
                x = abstractproperty(getx, setx)
        'abstractproperty' is deprecated. Use 'property' with 'abstractmethod'
        instead.
        """
        __isabstractmethod__ = True
    try:
        from _abc import (get_cache_token, _abc_init, _abc_register,
                          _abc_instancecheck, _abc_subclasscheck, _get_dump,
                          _reset_registry, _reset_caches)
    except ImportError:
        from _py_abc import ABCMeta, get_cache_token
        ABCMeta.__module__ = 'abc'
    else:
        class ABCMeta(type):
            """Metaclass for defining Abstract Base Classes (ABCs).
            Use this metaclass to create an ABC.  An ABC can be subclassed
            directly, and then acts as a mix-in class.  You can also register
            unrelated concrete classes (even built-in classes) and unrelated
            ABCs as 'virtual subclasses' -- these and their descendants will
            be considered subclasses of the registering ABC by the built-in
            issubclass() function, but the registering ABC won't show up in
            their MRO (Method Resolution Order) nor will method
            implementations defined by the registering ABC be callable (not
            even via super()).
            """
            def __new__(mcls, name, bases, namespace, **kwargs):
                cls = super().__new__(mcls, name, bases, namespace, **kwargs)
                _abc_init(cls)
                return cls
            def register(cls, subclass):
                """Register a virtual subclass of an ABC.
                Returns the subclass, to allow usage as a class decorator.
                """
                return _abc_register(cls, subclass)
            def __instancecheck__(cls, instance):
                """Override for isinstance(instance, cls)."""
                return _abc_instancecheck(cls, instance)
            def __subclasscheck__(cls, subclass):
                """Override for issubclass(subclass, cls)."""
                return _abc_subclasscheck(cls, subclass)
            def _dump_registry(cls, file=None):
                """Debug helper to print the ABC registry."""
                print(f"Class: {cls.__module__}.{cls.__qualname__}", file=file)
                print(f"Inv. counter: {get_cache_token()}", file=file)
                (_abc_registry, _abc_cache, _abc_negative_cache,
                 _abc_negative_cache_version) = _get_dump(cls)
                print(f"_abc_registry: {_abc_registry!r}", file=file)
                print(f"_abc_cache: {_abc_cache!r}", file=file)
                print(f"_abc_negative_cache: {_abc_negative_cache!r}", file=file)
                print(f"_abc_negative_cache_version: {_abc_negative_cache_version!r}",
                      file=file)
            def _abc_registry_clear(cls):
                """Clear the registry (for debugging or testing)."""
                _reset_registry(cls)
            def _abc_caches_clear(cls):
                """Clear the caches (for debugging or testing)."""
                _reset_caches(cls)
    class ABC(metaclass=ABCMeta):
        """Helper class that provides a standard way to create an ABC using
        inheritance.
        """
        __slots__ = ()