Name | openpyxl JSON |
Version |
3.1.2
JSON |
| download |
home_page | https://openpyxl.readthedocs.io |
Summary | A Python library to read/write Excel 2010 xlsx/xlsm files |
upload_time | 2023-03-11 16:58:38 |
maintainer | |
docs_url | https://pythonhosted.org/openpyxl/ |
author | See AUTHORS |
requires_python | >=3.6 |
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": "",
"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"
}