A Python module for creating Excel XLSX files.
Project Links
Meta
Author: John McNamara
Requires Python: >=3.6
Classifiers
Development Status
- 5 - Production/Stable
License
- OSI Approved :: BSD License
Programming Language
- Python
- Python :: 3 :: Only
- Python :: 3
- Python :: 3.8
- Python :: 3.9
- Python :: 3.10
- Python :: 3.11
- Python :: 3.12
- Python :: 3.13
XlsxWriter is a Python module for writing files in the Excel 2007+ XLSX file format.
XlsxWriter can be used to write text, numbers, formulas and hyperlinks to multiple worksheets and it supports features such as formatting and many more, including:
100% compatible Excel XLSX files.
Full formatting.
Merged cells.
Defined names.
Charts.
Autofilters.
Data validation and drop down lists.
Conditional formatting.
Worksheet PNG/JPEG/GIF/BMP/WMF/EMF images.
Rich multi-format strings.
Cell comments.
Integration with Pandas and Polars.
Textboxes.
Support for adding Macros.
Memory optimization mode for writing large files.
It supports Python 3.4+ and PyPy3 and uses standard libraries only.
Here is a simple example:
import xlsxwriter
# Create an new Excel file and add a worksheet.
workbook = xlsxwriter.Workbook("demo.xlsx")
worksheet = workbook.add_worksheet()
# Widen the first column to make the text clearer.
worksheet.set_column("A:A", 20)
# Add a bold format to use to highlight cells.
bold = workbook.add_format({"bold": True})
# Write some simple text.
worksheet.write("A1", "Hello")
# Text with formatting.
worksheet.write("A2", "World", bold)
# Write some numbers, with row/column notation.
worksheet.write(2, 0, 123)
worksheet.write(3, 0, 123.456)
# Insert an image.
worksheet.insert_image("B5", "logo.png")
workbook.close()
See the full documentation at: https://xlsxwriter.readthedocs.io
Release notes: https://xlsxwriter.readthedocs.io/changes.html
3.2.3
Apr 17, 2025
3.2.2
Jan 28, 2025
3.2.1
Jan 22, 2025
3.2.0
Feb 18, 2024
3.1.9
Oct 19, 2023
3.1.8
Oct 15, 2023
3.1.7
Oct 09, 2023
3.1.6
Oct 01, 2023
3.1.5
Sep 24, 2023
3.1.4
Sep 18, 2023
3.1.3
Sep 08, 2023
3.1.2
May 28, 2023
3.1.1
May 21, 2023
3.1.0
Apr 13, 2023
3.0.9
Mar 10, 2023
3.0.8
Feb 03, 2023
3.0.7
Jan 14, 2023
3.0.6
Jan 05, 2023
3.0.5
Dec 31, 2022
3.0.4
Dec 28, 2022
3.0.3
Feb 27, 2022
3.0.2
Nov 01, 2021
3.0.1
Aug 10, 2021
2.0.0
Aug 09, 2021
1.4.5
Jul 30, 2021
1.4.4
Jul 04, 2021
1.4.3
May 12, 2021
1.4.2
May 07, 2021
1.4.1
May 06, 2021
1.4.0
Apr 23, 2021
1.3.9
Apr 14, 2021
1.3.8
Mar 29, 2021
1.3.7
Oct 13, 2020
1.3.6
Sep 23, 2020
1.3.5
Sep 21, 2020
1.3.4
Sep 18, 2020
1.3.3
Aug 13, 2020
1.3.2
Aug 06, 2020
1.3.1
Aug 03, 2020
1.3.0
Jul 30, 2020
1.2.9
May 29, 2020
1.2.8
Feb 22, 2020
1.2.7
Dec 23, 2019
1.2.6
Nov 15, 2019
1.2.5
Nov 10, 2019
1.2.4
Nov 09, 2019
1.2.3
Nov 08, 2019
1.2.2
Oct 16, 2019
1.2.1
Sep 14, 2019
1.2.0
Aug 25, 2019
1.1.9
Aug 19, 2019
1.1.8
May 05, 2019
1.1.7
Apr 20, 2019
1.1.6
Apr 07, 2019
1.1.5
Feb 23, 2019
1.1.4
Feb 10, 2019
1.1.3
Feb 09, 2019
1.1.2
Oct 20, 2018
1.1.1
Sep 22, 2018
1.1.0
Sep 02, 2018
1.0.9
Aug 27, 2018
1.0.8
Aug 26, 2018
1.0.7
Aug 15, 2018
1.0.6
Aug 14, 2018
1.0.5
May 19, 2018
1.0.4
Apr 14, 2018
1.0.3
Apr 10, 2018
1.0.2
Oct 15, 2017
1.0.1
Oct 14, 2017
1.0.0
Sep 15, 2017
0.9.9
Sep 05, 2017
0.9.8
Jul 01, 2017
0.9.7
Jun 25, 2017
0.9.6
Dec 26, 2016
0.9.5
Dec 24, 2016
0.9.4
Dec 02, 2016
0.9.3
Jul 09, 2016
0.9.2
Jun 12, 2016
0.9.1
Jun 07, 2016
0.9.0
Jun 06, 2016
0.8.9
May 31, 2016
0.8.8
May 30, 2016
0.8.7
May 14, 2016
0.8.6
Apr 27, 2016
0.8.5
Apr 17, 2016
0.8.4
Jan 16, 2016
0.8.3
Jan 14, 2016
0.8.2
Jan 13, 2016
0.8.1
Jan 12, 2016
0.8.0
Jan 11, 2016
0.7.9
Jan 09, 2016
0.7.8
Jan 06, 2016
0.7.7
Oct 18, 2015
0.7.6
Oct 07, 2015
0.7.5
Oct 04, 2015
0.7.4
Sep 29, 2015
0.7.3
May 07, 2015
0.7.2
Mar 29, 2015
0.7.1
Mar 24, 2015
0.7.0
Mar 21, 2015
0.6.9
Mar 20, 2015
0.6.8
Mar 18, 2015
0.6.7
Mar 02, 2015
0.6.6
Jan 16, 2015
0.6.5
Dec 31, 2014
0.6.4
Nov 15, 2014
0.6.3
Nov 06, 2014
0.6.2
Nov 01, 2014
0.6.1
Oct 29, 2014
0.6.0
Oct 14, 2014
0.5.9
Oct 11, 2014
0.5.8
Sep 29, 2014
0.5.7
Aug 12, 2014
0.5.6
Jul 22, 2014
0.5.5
May 05, 2014
0.5.4
May 04, 2014
0.5.3
Feb 20, 2014
0.5.2
Dec 31, 2013
0.5.1
Dec 02, 2013
0.5.0
Nov 19, 2013
0.4.9
Nov 17, 2013
0.4.8
Nov 13, 2013
0.4.7
Nov 09, 2013
0.4.6
Oct 22, 2013
0.4.5
Oct 21, 2013
0.4.4
Oct 16, 2013
0.4.3
Sep 12, 2013
0.4.2
Aug 29, 2013
0.4.1
Aug 28, 2013
0.4.0
Aug 26, 2013
0.3.9
Aug 24, 2013
0.3.8
Aug 23, 2013
0.3.7
Aug 15, 2013
0.3.6
Jul 26, 2013
0.3.5
Jun 28, 2013
0.3.4
Jun 27, 2013
0.3.3
Jun 10, 2013
0.3.2
May 01, 2013
0.3.1
Apr 27, 2013
0.3.0
Apr 11, 2013
0.2.9
Apr 07, 2013
0.2.8
Apr 03, 2013
0.2.7
Apr 02, 2013
0.2.6
Apr 01, 2013
0.2.5
Apr 01, 2013
0.2.4
Mar 31, 2013
0.2.3
Mar 27, 2013
0.2.2
Mar 27, 2013
0.2.1
Mar 25, 2013
0.2.0
Mar 24, 2013
0.1.9
Mar 19, 2013
0.1.8
Mar 19, 2013
0.1.7
Mar 18, 2013
0.1.6
Mar 17, 2013
0.1.5
Mar 10, 2013
0.1.4
Mar 08, 2013
0.1.3
Mar 07, 2013
0.1.2
Mar 06, 2013
0.1.1
Mar 03, 2013
0.1.0
Feb 28, 2013
0.0.9
Feb 27, 2013
0.0.8
Feb 26, 2013
0.0.7
Feb 25, 2013
0.0.6
Feb 23, 2013
0.0.5
Feb 22, 2013
0.0.4
Feb 21, 2013
0.0.3
Feb 20, 2013
0.0.2
Feb 18, 2013
0.0.1
Feb 17, 2013
0.0rc0
Sep 18, 2020
Wheel compatibility matrix
Files in release
No dependencies