Metadata-Version: 2.1 Name: openpyxl Version: 3.0.7 Summary: A Python library to read/write Excel 2010 xlsx/xlsm files Home-page: https://openpyxl.readthedocs.io Author: See AUTHORS Author-email: charlie.clark@clark-consulting.eu License: MIT Project-URL: Documentation, https://openpyxl.readthedocs.io/en/stable/ Project-URL: Source, https://foss.heptapod.net/openpyxl/openpyxl Project-URL: Tracker, https://foss.heptapod.net/openpyxl/openpyxl/-/issues Platform: UNKNOWN Classifier: Development Status :: 5 - Production/Stable Classifier: Operating System :: MacOS :: MacOS X Classifier: Operating System :: Microsoft :: Windows Classifier: Operating System :: POSIX Classifier: License :: OSI Approved :: MIT License Classifier: Programming Language :: Python Classifier: Programming Language :: Python :: 3.6 Classifier: Programming Language :: Python :: 3.7 Classifier: Programming Language :: Python :: 3.8 Classifier: Programming Language :: Python :: 3.9 Requires-Python: >=3.6, Requires-Dist: et-xmlfile .. 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