A Python library to read/write Excel 2010 xlsx/xlsm files
Project Links
Meta
Author: See AUTHORS
Requires Python: >=3.8
Classifiers
Development Status
- 5 - Production/Stable
Operating System
- MacOS :: MacOS X
- Microsoft :: Windows
- POSIX
License
- OSI Approved :: MIT License
Programming Language
- Python
- Python :: 3.6
- Python :: 3.7
- Python :: 3.8
- Python :: 3.9
- Python :: 3.10
- Python :: 3.11
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
3.2.0b1
May 19, 2022
3.1.5
Jun 28, 2024
3.1.4
Jun 12, 2024
3.1.3
May 29, 2024
3.1.2
Mar 11, 2023
3.1.1
Feb 13, 2023
3.1.0
Jan 31, 2023
3.0.10
May 19, 2022
3.0.9
Sep 22, 2021
3.0.7
Mar 09, 2021
3.0.6
Jan 14, 2021
3.0.5
Aug 21, 2020
3.0.4
Jun 24, 2020
3.0.3
Jan 10, 2020
3.0.2
Nov 25, 2019
3.0.1
Nov 14, 2019
3.0.0
Sep 25, 2019
2.6.4
Sep 25, 2019
2.6.3
Aug 19, 2019
2.6.2
Mar 29, 2019
2.6.1
Mar 04, 2019
2.6.0
Feb 06, 2019
2.6.0b1
Jan 08, 2019
2.6.0a1
Nov 21, 2018
2.5.14
Jan 23, 2019
2.5.12
Nov 29, 2018
2.5.11
Nov 21, 2018
2.5.10
Nov 13, 2018
2.5.9
Oct 19, 2018
2.5.8
Sep 25, 2018
2.5.7
Sep 13, 2018
2.5.6
Aug 30, 2018
2.5.5
Aug 04, 2018
2.5.4
Jun 07, 2018
2.5.3
Apr 18, 2018
2.5.2
Apr 06, 2018
2.5.1
Mar 12, 2018
2.5.0
Jan 24, 2018
2.4.11
Jan 24, 2018
2.4.10
Jan 19, 2018
2.4.9
Oct 19, 2017
2.4.8
May 30, 2017
2.4.7
Apr 24, 2017
2.4.5
Mar 07, 2017
2.4.4
Feb 23, 2017
2.4.2
Jan 31, 2017
2.4.1
Nov 23, 2016
2.4.0
Sep 15, 2016
2.3.5
Apr 11, 2016
2.3.4
Mar 16, 2016
2.3.3
Jan 18, 2016
2.3.2
Dec 06, 2015
2.3.1
Nov 20, 2015
2.3.0
Oct 20, 2015
2.2.6
Sep 04, 2015
2.2.5
Jun 29, 2015
2.2.4
Jun 17, 2015
2.2.3
May 26, 2015
2.2.2
Apr 28, 2015
2.2.1
Mar 31, 2015
2.2.0
Mar 11, 2015
2.1.5
Feb 18, 2015
2.1.4
Dec 16, 2014
2.1.3
Dec 09, 2014
2.1.2
Oct 23, 2014
2.1.1
Oct 08, 2014
2.1.0
Sep 21, 2014
2.0.5
Aug 08, 2014
2.0.4
Jun 25, 2014
2.0.3
May 22, 2014
2.0.2
May 13, 2014
1.8.6
May 05, 2014
1.8.5
Mar 25, 2014
1.8.4
Feb 25, 2014
1.8.3
Feb 09, 2014
1.8.2
Jan 21, 2014
1.8.1
Jan 14, 2014
1.8.0
Jan 08, 2014
1.7.0
Nov 13, 2013
1.6.2
Apr 18, 2013
1.6.1
Oct 28, 2012
1.5.8
Mar 03, 2012
1.5.7
Jan 22, 2012
1.5.6
Oct 31, 2011
1.5.5
Oct 11, 2011
1.5.4
Sep 05, 2011
1.5.3
Sep 05, 2011
1.5.2
Apr 07, 2011
1.5.1
Apr 07, 2011
1.5.0
Mar 15, 2011
1.2.3
Dec 07, 2010
1.1.7
Sep 11, 2010
1.1.6
Sep 10, 2010
1.1.5
Sep 03, 2010
1.1.4
Sep 01, 2010
1.1.0
Aug 11, 2010
0.0rc0
Aug 11, 2010
Wheel compatibility matrix
Files in release
Extras:
None
Dependencies:
et-xmlfile