xlsxwriter · PyPI

Some features may not work without JavaScript. Please try enabling it if you encounter problems.

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 images.
Rich multi-format strings.
Cell comments.
Integration with Pandas.
Textboxes.
Memory optimisation mode for writing large files.

It supports Python 2.5, 2.6, 2.7, 3.1, 3.2, 3.3, 3.4, Jython and PyPy 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()

https://raw.github.com/jmcnamara/XlsxWriter/master/dev/docs/source/_images/demo.png

See the full documentation at: http://xlsxwriter.readthedocs.org

Release notes: http://xlsxwriter.readthedocs.org/changes.html

Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

XlsxWriter-0.7.4.tar.gz (232.3 kB view details)

Uploaded Sep 29, 2015 Source

Built Distribution

If you're not sure about the file name format, learn more about wheel file names.

The dropdown lists show the available interpreters, ABIs, and platforms. Enable javascript to be able to filter the list of wheel files.

XlsxWriter-0.7.4-py2.py3-none-any.whl (133.2 kB view details)

Uploaded Sep 29, 2015 Python 2Python 3

File details

Details for the file XlsxWriter-0.7.4.tar.gz.

File metadata

Download URL: XlsxWriter-0.7.4.tar.gz
Upload date: Sep 29, 2015
Size: 232.3 kB
Tags: Source
Uploaded using Trusted Publishing? No

File hashes

Hashes for XlsxWriter-0.7.4.tar.gz
Algorithm	Hash digest
SHA256	`e3192763b377a588fc06113836cf74a565926168929e55ba451baa684e857b62`
MD5	`c62eb04c5be74150bed9f3fa58ca6bdd`
BLAKE2b-256	`5d5b2de2063c74bac22da8c23cbe2bc1ce9833c414b996fafa7da5e256f13ce3`

See more details on using hashes here.

File details

Details for the file XlsxWriter-0.7.4-py2.py3-none-any.whl.

File metadata

Download URL: XlsxWriter-0.7.4-py2.py3-none-any.whl
Upload date: Sep 29, 2015
Size: 133.2 kB
Tags: Python 2, Python 3
Uploaded using Trusted Publishing? No

File hashes

Hashes for XlsxWriter-0.7.4-py2.py3-none-any.whl
Algorithm	Hash digest
SHA256	`bd4d754ece38306d62b87bfa307df472ec820b75222f4fc0658ec5ce8f5383a3`
MD5	`cf78ff0697804945b9a48ffd92cf949f`
BLAKE2b-256	`e5b9089e8f43b82e0b09f44f9ee2dbc6c482b5601672a9867026c21884b15130`

See more details on using hashes here.

Release history Release notifications | RSS feed

Sep 16, 2025 2 files

Sep 14, 2025 2 files

Sep 13, 2025 2 files

Sep 12, 2025 2 files

Jun 17, 2025 2 files

Jun 17, 2025 2 files

Yanked

Apr 17, 2025 2 files

Jan 28, 2025 2 files

Jan 22, 2025 2 files

Feb 18, 2024 2 files

Oct 19, 2023 2 files

Oct 15, 2023 2 files

Oct 9, 2023 2 files

Oct 1, 2023 2 files

Sep 24, 2023 2 files

Sep 18, 2023 2 files

Sep 8, 2023 2 files

May 28, 2023 2 files

May 21, 2023 2 files

Apr 13, 2023 2 files

Mar 10, 2023 2 files

Feb 3, 2023 2 files

Jan 14, 2023 2 files

Jan 5, 2023 2 files

Dec 31, 2022 2 files

Dec 28, 2022 2 files

Feb 27, 2022 2 files

Nov 1, 2021 2 files

Aug 10, 2021 2 files

Aug 9, 2021 2 files

Jul 30, 2021 2 files

Jul 4, 2021 2 files

May 12, 2021 2 files

May 7, 2021 2 files

May 6, 2021 2 files

Apr 23, 2021 2 files

Apr 14, 2021 2 files

Mar 29, 2021 2 files

Oct 13, 2020 2 files

Sep 23, 2020 2 files

Sep 21, 2020 2 files

Sep 18, 2020 2 files

Aug 13, 2020 3 files

Aug 6, 2020 2 files

Aug 3, 2020 2 files

Jul 30, 2020 2 files

May 29, 2020 2 files

Feb 22, 2020 2 files

Dec 23, 2019 2 files

Nov 15, 2019 2 files

Nov 10, 2019 2 files

Nov 9, 2019 2 files

Nov 8, 2019 2 files

Oct 16, 2019 2 files

Sep 14, 2019 2 files

Aug 25, 2019 2 files

Aug 19, 2019 2 files

May 5, 2019 2 files

Apr 20, 2019 2 files

Apr 7, 2019 2 files

Feb 23, 2019 2 files

Feb 10, 2019 2 files

Feb 9, 2019 2 files

Oct 20, 2018 2 files

Sep 22, 2018 2 files

Sep 2, 2018 2 files

Aug 27, 2018 2 files

Aug 26, 2018 2 files

Aug 15, 2018 2 files

Aug 14, 2018 2 files

May 19, 2018 2 files

Apr 14, 2018 2 files

Apr 10, 2018 2 files

Oct 15, 2017 2 files

Oct 14, 2017 2 files

Sep 15, 2017 2 files

Sep 5, 2017 2 files

Jul 1, 2017 2 files

Jun 25, 2017 2 files

Dec 26, 2016 2 files

Dec 24, 2016 2 files

Dec 2, 2016 2 files

Jul 9, 2016 2 files

Jun 12, 2016 2 files

Jun 7, 2016 2 files

Jun 6, 2016 2 files

May 31, 2016 2 files

May 30, 2016 2 files

May 14, 2016 2 files

Apr 27, 2016 2 files

Apr 17, 2016 2 files

Jan 16, 2016 2 files

Jan 14, 2016 2 files

Jan 13, 2016 2 files

Jan 12, 2016 2 files

Jan 11, 2016 2 files

Jan 9, 2016 2 files

Jan 6, 2016 2 files

Oct 18, 2015 2 files

Oct 7, 2015 2 files

Oct 4, 2015 2 files

This release

0.7.4 This release

Sep 29, 2015 2 files

May 7, 2015 2 files

Mar 29, 2015 2 files

Mar 24, 2015 2 files

Mar 21, 2015 2 files

Mar 20, 2015 2 files

Mar 18, 2015 2 files

Mar 2, 2015 2 files

Jan 16, 2015 2 files

Dec 31, 2014 2 files

Nov 15, 2014 2 files

Nov 6, 2014 2 files

Nov 1, 2014 2 files

Oct 29, 2014 2 files

Oct 14, 2014 2 files

Oct 11, 2014 2 files

Sep 29, 2014 2 files

Aug 12, 2014 1 file

Jul 22, 2014 1 file

May 5, 2014 1 file

May 4, 2014 1 file

Feb 20, 2014 1 file

Dec 31, 2013 1 file

Dec 2, 2013 1 file

Nov 19, 2013 1 file

Nov 17, 2013 1 file

Nov 13, 2013 1 file

Nov 9, 2013 1 file

Oct 22, 2013 1 file

Oct 21, 2013 1 file

Oct 16, 2013 1 file

Sep 12, 2013 1 file

Aug 29, 2013 1 file

Aug 28, 2013 1 file

Aug 26, 2013 1 file

Aug 24, 2013 1 file

Aug 23, 2013 1 file

Aug 15, 2013 1 file

Jul 26, 2013 1 file

Jun 28, 2013 1 file

Jun 27, 2013 1 file

Jun 10, 2013 1 file

May 1, 2013 1 file

Apr 27, 2013 1 file

Apr 11, 2013 1 file

Apr 7, 2013 1 file

Apr 3, 2013 1 file

Apr 2, 2013 1 file

Apr 1, 2013 1 file

Apr 1, 2013 1 file

Mar 31, 2013 1 file

Mar 27, 2013 1 file

Mar 27, 2013 1 file

Mar 25, 2013 1 file

Mar 24, 2013 1 file

Mar 19, 2013 1 file

Mar 19, 2013 1 file

Mar 18, 2013 1 file

Mar 17, 2013 1 file

Mar 10, 2013 1 file

Mar 8, 2013 1 file

Mar 7, 2013 1 file

Mar 6, 2013 1 file

Mar 3, 2013 1 file

Feb 28, 2013 1 file

Feb 27, 2013 1 file

Feb 26, 2013 1 file

Feb 25, 2013 1 file

Feb 23, 2013 1 file

Feb 22, 2013 1 file

Feb 21, 2013 1 file

Feb 20, 2013 1 file

Feb 18, 2013 1 file

Feb 17, 2013 1 file

Supported by

AWS Cloud computing and Security Sponsor

Datadog Monitoring

Depot Continuous Integration

Google Download Analytics

Sentry Error logging

StatusPage Status page