| Name | openpyxl JSON |
| Version |
3.1.4
JSON |
| download |
| home_page | https://openpyxl.readthedocs.io |
| Summary | A Python library to read/write Excel 2010 xlsx/xlsm files |
| upload_time | 2024-06-12 17:38:15 |
| maintainer | None |
| docs_url | https://pythonhosted.org/openpyxl/ |
| author | See AUTHORS |
| requires_python | >=3.8 |
| license | MIT |
| 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": null,
"docs_url": "https://pythonhosted.org/openpyxl/",
"requires_python": ">=3.8",
"maintainer_email": null,
"keywords": null,
"author": "See AUTHORS",
"author_email": "charlie.clark@clark-consulting.eu",
"download_url": "https://files.pythonhosted.org/packages/14/b8/acf74229f1b2d9e961f155e0be04e4629a1b53b3eeb4f2ac35c10032cf1b/openpyxl-3.1.4.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.4",
"project_urls": {
"Documentation": "https://openpyxl.readthedocs.io/en/stable/",
"Homepage": "https://openpyxl.readthedocs.io",
"Source": "https://foss.heptapod.net/openpyxl/openpyxl",
"Tracker": "https://foss.heptapod.net/openpyxl/openpyxl/-/issues"
},
"split_keywords": [],
"urls": [
{
"comment_text": "",
"digests": {
"blake2b_256": "30d0abcdb0669931be3a98881e6d7851605981693e93a7924061c67d0cd9f292",
"md5": "7b69c8cdccf22f0244f75d90255d37d1",
"sha256": "ec17f6483f2b8f7c88c57e5e5d3b0de0e3fb9ac70edc084d28e864f5b33bbefd"
},
"downloads": -1,
"filename": "openpyxl-3.1.4-py2.py3-none-any.whl",
"has_sig": false,
"md5_digest": "7b69c8cdccf22f0244f75d90255d37d1",
"packagetype": "bdist_wheel",
"python_version": "py2.py3",
"requires_python": ">=3.8",
"size": 251355,
"upload_time": "2024-06-12T17:38:13",
"upload_time_iso_8601": "2024-06-12T17:38:13.584096Z",
"url": "https://files.pythonhosted.org/packages/30/d0/abcdb0669931be3a98881e6d7851605981693e93a7924061c67d0cd9f292/openpyxl-3.1.4-py2.py3-none-any.whl",
"yanked": false,
"yanked_reason": null
},
{
"comment_text": "",
"digests": {
"blake2b_256": "14b8acf74229f1b2d9e961f155e0be04e4629a1b53b3eeb4f2ac35c10032cf1b",
"md5": "16c18366af66786738f3cefd90966722",
"sha256": "8d2c8adf5d20d6ce8f9bca381df86b534835e974ed0156dacefa76f68c1d69fb"
},
"downloads": -1,
"filename": "openpyxl-3.1.4.tar.gz",
"has_sig": false,
"md5_digest": "16c18366af66786738f3cefd90966722",
"packagetype": "sdist",
"python_version": "source",
"requires_python": ">=3.8",
"size": 186697,
"upload_time": "2024-06-12T17:38:15",
"upload_time_iso_8601": "2024-06-12T17:38:15.793222Z",
"url": "https://files.pythonhosted.org/packages/14/b8/acf74229f1b2d9e961f155e0be04e4629a1b53b3eeb4f2ac35c10032cf1b/openpyxl-3.1.4.tar.gz",
"yanked": false,
"yanked_reason": null
}
],
"upload_time": "2024-06-12 17:38:15",
"github": false,
"gitlab": false,
"bitbucket": false,
"codeberg": false,
"lcname": "openpyxl"
}
