openpyxl


Nameopenpyxl JSON
Version 3.1.2 PyPI version JSON
download
home_pagehttps://openpyxl.readthedocs.io
SummaryA Python library to read/write Excel 2010 xlsx/xlsm files
upload_time2023-03-11 16:58:38
maintainer
docs_urlhttps://pythonhosted.org/openpyxl/
authorSee AUTHORS
requires_python>=3.6
licenseMIT
keywords
VCS
bugtrack_url
requirements No requirements were recorded.
Travis-CI No Travis.
coveralls test coverage No coveralls.
            .. image:: https://coveralls.io/repos/bitbucket/openpyxl/openpyxl/badge.svg?branch=default
    :target: https://coveralls.io/bitbucket/openpyxl/openpyxl?branch=default
    :alt: coverage status

Introduction
------------

openpyxl is a Python library to read/write Excel 2010 xlsx/xlsm/xltx/xltm files.

It was born from lack of existing library to read/write natively from Python
the Office Open XML format.

All kudos to the PHPExcel team as openpyxl was initially based on PHPExcel.


Security
--------

By default openpyxl does not guard against quadratic blowup or billion laughs
xml attacks. To guard against these attacks install defusedxml.

Mailing List
------------

The user list can be found on http://groups.google.com/group/openpyxl-users


Sample code::

    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")


Documentation
-------------

The documentation is at: https://openpyxl.readthedocs.io

* installation methods
* code examples
* instructions for contributing

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

            

Raw data

            {
    "_id": null,
    "home_page": "https://openpyxl.readthedocs.io",
    "name": "openpyxl",
    "maintainer": "",
    "docs_url": "https://pythonhosted.org/openpyxl/",
    "requires_python": ">=3.6",
    "maintainer_email": "",
    "keywords": "",
    "author": "See AUTHORS",
    "author_email": "charlie.clark@clark-consulting.eu",
    "download_url": "https://files.pythonhosted.org/packages/42/e8/af028681d493814ca9c2ff8106fc62a4a32e4e0ae14602c2a98fc7b741c8/openpyxl-3.1.2.tar.gz",
    "platform": null,
    "description": ".. image:: https://coveralls.io/repos/bitbucket/openpyxl/openpyxl/badge.svg?branch=default\n    :target: https://coveralls.io/bitbucket/openpyxl/openpyxl?branch=default\n    :alt: coverage status\n\nIntroduction\n------------\n\nopenpyxl is a Python library to read/write Excel 2010 xlsx/xlsm/xltx/xltm files.\n\nIt was born from lack of existing library to read/write natively from Python\nthe Office Open XML format.\n\nAll kudos to the PHPExcel team as openpyxl was initially based on PHPExcel.\n\n\nSecurity\n--------\n\nBy default openpyxl does not guard against quadratic blowup or billion laughs\nxml attacks. To guard against these attacks install defusedxml.\n\nMailing List\n------------\n\nThe user list can be found on http://groups.google.com/group/openpyxl-users\n\n\nSample code::\n\n    from openpyxl import Workbook\n    wb = Workbook()\n\n    # grab the active worksheet\n    ws = wb.active\n\n    # Data can be assigned directly to cells\n    ws['A1'] = 42\n\n    # Rows can also be appended\n    ws.append([1, 2, 3])\n\n    # Python types will automatically be converted\n    import datetime\n    ws['A2'] = datetime.datetime.now()\n\n    # Save the file\n    wb.save(\"sample.xlsx\")\n\n\nDocumentation\n-------------\n\nThe documentation is at: https://openpyxl.readthedocs.io\n\n* installation methods\n* code examples\n* instructions for contributing\n\nRelease notes: https://openpyxl.readthedocs.io/en/stable/changes.html\n",
    "bugtrack_url": null,
    "license": "MIT",
    "summary": "A Python library to read/write Excel 2010 xlsx/xlsm files",
    "version": "3.1.2",
    "split_keywords": [],
    "urls": [
        {
            "comment_text": "",
            "digests": {
                "blake2b_256": "6a94a59521de836ef0da54aaf50da6c4da8fb4072fb3053fa71f052fd9399e7a",
                "md5": "797657015056d50de2bc003d8a9379c2",
                "sha256": "f91456ead12ab3c6c2e9491cf33ba6d08357d802192379bb482f1033ade496f5"
            },
            "downloads": -1,
            "filename": "openpyxl-3.1.2-py2.py3-none-any.whl",
            "has_sig": false,
            "md5_digest": "797657015056d50de2bc003d8a9379c2",
            "packagetype": "bdist_wheel",
            "python_version": "py2.py3",
            "requires_python": ">=3.6",
            "size": 249985,
            "upload_time": "2023-03-11T16:58:36",
            "upload_time_iso_8601": "2023-03-11T16:58:36.257231Z",
            "url": "https://files.pythonhosted.org/packages/6a/94/a59521de836ef0da54aaf50da6c4da8fb4072fb3053fa71f052fd9399e7a/openpyxl-3.1.2-py2.py3-none-any.whl",
            "yanked": false,
            "yanked_reason": null
        },
        {
            "comment_text": "",
            "digests": {
                "blake2b_256": "42e8af028681d493814ca9c2ff8106fc62a4a32e4e0ae14602c2a98fc7b741c8",
                "md5": "fd7b9e3c703e2889f6a1edbdb9737768",
                "sha256": "a6f5977418eff3b2d5500d54d9db50c8277a368436f4e4f8ddb1be3422870184"
            },
            "downloads": -1,
            "filename": "openpyxl-3.1.2.tar.gz",
            "has_sig": false,
            "md5_digest": "fd7b9e3c703e2889f6a1edbdb9737768",
            "packagetype": "sdist",
            "python_version": "source",
            "requires_python": ">=3.6",
            "size": 185977,
            "upload_time": "2023-03-11T16:58:38",
            "upload_time_iso_8601": "2023-03-11T16:58:38.780026Z",
            "url": "https://files.pythonhosted.org/packages/42/e8/af028681d493814ca9c2ff8106fc62a4a32e4e0ae14602c2a98fc7b741c8/openpyxl-3.1.2.tar.gz",
            "yanked": false,
            "yanked_reason": null
        }
    ],
    "upload_time": "2023-03-11 16:58:38",
    "github": false,
    "gitlab": false,
    "bitbucket": false,
    "lcname": "openpyxl"
}
        
Elapsed time: 0.04546s