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)
  • openpyxl - 读/写 Excel 2010 xlsx/xlsm 文件的 Python 库

    作者: Eric Gazoni, Charlie Clark
    源代码: https://foss.heptapod.net/openpyxl/openpyxl
    问题: https://foss.heptapod.net/openpyxl/openpyxl/-/issues
    生成: 2021 年 3 月 9 日
    许可: MIT/Expat
    版本: 3.0.7

    介绍

    openpyxl 是读/写 Excel 2010 xlsx/xlsm/xltx/xltm 文件的 Python 库。

    它诞生于缺乏从 Python 读/写本地 Office Open XML 格式的现有库。

    所有荣誉归 PHPExcel 团队,因为 openpyxl 最初基于 PHPExcel。

    安全

    默认情况下,openpyxl 不防范二次爆炸或 billion laughs xml 攻击。为防范这些攻击,安装 defusedxml。

    邮件列表

    可以找到用户列表在 http://groups.google.com/group/openpyxl-users

    样本代码:

    from openpyxl import Workbook
    wb = Workbook()
    # grab the active worksheet
    ws = wb.active
    # Data can be assigned directly to cells
    ws['A1'] = 42
    # Rows can also be appended
    ws.append([1, 2, 3])
    # Python types will automatically be converted
    import datetime
    ws['A2'] = datetime.datetime.now()
    # Save the file
    wb.save("sample.xlsx")
    								

    文档编制

    文档编制在: https://openpyxl.readthedocs.io

    • 安装方法
    • 代码范例
    • 贡献指导

    Release notes: https://openpyxl.readthedocs.io/en/stable/changes.html

    支持

    This is an open source project, maintained by volunteers in their spare time. This may well mean that particular features or functions that you would like are missing. But things don’t have to stay that way. You can contribute the project 开发 yourself or contract a developer for particular features.

    Professional support for openpyxl is available from Clark Consulting & Research and Adimian . Donations to the project to support further development and maintenance are welcome.

    Bug reports and feature requests should be submitted using the issue tracker . Please provide a full traceback of any error you see and if possible a sample file. If for reasons of confidentiality you are unable to make a file publicly available then contact of one the developers.

    The repository is being provided by Octobus and Clever Cloud .

    如何贡献

    Any help will be greatly appreciated, just follow those steps:

    1. Please join the group and create a branch ( https://foss.heptapod.net/openpyxl/openpyxl/ ) and follow the Merge Request Start Guide . for each independent feature, don’t try to fix all problems at the same time, it’s easier for those who will review and merge your changes ;-)

    2. Hack hack hack

    3. Don’t forget to add unit tests for your changes! (YES, even if it’s a one-liner, changes without tests will not be accepted.) There are plenty of examples in the source if you lack know-how or inspiration.

    4. If you added a whole new feature, or just improved something, you can be proud of it, so add yourself to the AUTHORS file :-)

    5. Let people know about the shiny thing you just implemented, update the docs!

    6. When it’s done, just issue a pull request (click on the large “pull request” button on your repository) and wait for your code to be reviewed, and, if you followed all theses steps, merged into the main repository.

    进一步信息见 开发

    Other ways to help

    There are several ways to contribute, even if you can’t code (or can’t code well):

    • triaging bugs on the bug tracker: closing bugs that have already been closed, are not relevant, cannot be reproduced, …
    • updating documentation in virtually every area: many large features have been added (mainly about charts and images at the moment) but without any documentation, it’s pretty hard to do anything with it
    • proposing compatibility fixes for different versions of Python: we support 3.6, 3.7, 3.8 and 3.9.

    安装

    Install openpyxl using pip. It is advisable to do this in a Python virtualenv without system packages:

    $ pip install openpyxl
    								

    注意

    There is support for the popular lxml library which will be used if it is installed. This is particular useful when creating large files.

    警告

    To be able to include images (jpeg, png, bmp,…) into an openpyxl file, you will also need the “pillow” library that can be installed with:

    $ pip install pillow
    									

    or browse https://pypi.python.org/pypi/Pillow/ , pick the latest version and head to the bottom of the page for Windows binaries.

    Working with a checkout

    Sometimes you might want to work with the checkout of a particular version. This may be the case if bugs have been fixed but a release has not yet been made.

    $ pip install -e hg+https://foss.heptapod.net/openpyxl/openpyxl/@3.0#egg=openpyxl
    							

    给开发者的信息

    索引和表格

    发行注意事项