| Port variant | v11 |
| Summary | Read/write Excel 2010 xlsx/xlsm files (3.11) |
| Package version | 3.1.2 |
| Homepage | https://openpyxl.readthedocs.io |
| Keywords | python |
| Maintainer | Python Automaton |
| License | Not yet specified |
| Other variants | v12 |
| Ravenports | Buildsheet | History |
| Ravensource | Port Directory | History |
| Last modified | 24 JAN 2024, 23:28:02 UTC |
| Port created | 13 JAN 2024, 02:07:09 UTC |
| single | :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 |
| Build (only) |
python-pip:single:v11 autoselect-python:single:standard |
| Build and Runtime | python311:single:standard |
| Runtime (only) | python-et-xmlfile:single:v11 |
| main | mirror://PYPIWHL/6a/94/a59521de836ef0da54aaf50da6c4da8fb4072fb3053fa71f052fd9399e7a |
| No other ports depend on this one. |