Skip to main content

XlsxWriter

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.

  • 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()
https://raw.github.com/jmcnamara/XlsxWriter/master/dev/docs/source/_images/demo.png

See the full documentation at: https://xlsxwriter.readthedocs.io

Release notes: https://xlsxwriter.readthedocs.io/changes.html

Metadata

Release files for xlsxwriter 3.0.3

For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.

Source distribution (sdist)

Source distribution for xlsxwriter 3.0.3
File Size Uploaded Provenance Actions
XlsxWriter-3.0.3.tar.gz 264.4 kB Without provenance Details for XlsxWriter-3.0.3.tar.gz

Built distribution (wheel)

Table of built distributions (wheels) for xlsxwriter 3.0.3
File Interpreter ABI Platform Actions
XlsxWriter-3.0.3-py3-none-any.whl Python 3 none any Details for XlsxWriter-3.0.3-py3-none-any.whl

Total release size: 414.4 kB

Release files / XlsxWriter-3.0.3.tar.gz

Download URL XlsxWriter-3.0.3.tar.gz
Size 264.4 kB
Tags Source
SHA-256 checksum
How to use checksums
e89f4a1d2fa2c9ea15cde77de95cd3fd8b0345d0efb3964623f395c8c4988b7f
BLAKE2b-256 checksum
How to use checksums
530491ff43803c3e88c32aa272fdbda5859fc3c3b50b0de3a1e439cc57455330
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
No
Uploaded via twine/3.4.2 importlib_metadata/4.6.3 pkginfo/1.7.1 requests/2.21.0 requests-toolbelt/0.9.1 tqdm/4.62.0 CPython/3.9.6

Release files / XlsxWriter-3.0.3-py3-none-any.whl

Download URL XlsxWriter-3.0.3-py3-none-any.whl
Size 150.0 kB
Tags Python 3
SHA-256 checksum
How to use checksums
df0aefe5137478d206847eccf9f114715e42aaea077e6a48d0e8a2152e983010
BLAKE2b-256 checksum
How to use checksums
ef9530f6ee57f10232e2055a85c3e4c8db7d38ab5f1349b6cdced85cb8acd5e6
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
No
Uploaded via twine/3.4.2 importlib_metadata/4.6.3 pkginfo/1.7.1 requests/2.21.0 requests-toolbelt/0.9.1 tqdm/4.62.0 CPython/3.9.6

Security for xlsxwriter 3.0.3

Provenance

Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.

No provenance found

None of the files in this release were uploaded with provenance metadata.

A note on package security

PyPI is a repository for distributing packages, not a service for auditing them. While third-party security researchers and our staff do their best to detect and remove malicious packages, PyPI cannot guarantee the quality, security or suitability of any given package.

To learn more about protecting yourself from malicious actors, visit our package security documentation.

Release history Release notifications | RSS feed

This release

3.0.3 This release

2 release files No provenance

Anthropic, PBC Visionary sponsor Bloomberg Visionary sponsor Hudson River Trading Visionary sponsor Meta Visionary sponsor NVIDIA Visionary sponsor Microsoft Sustainability sponsor Depot Continuous Integration AWS Cloud computing and Security Sponsor Datadog Monitoring Fastly CDN Google Download Analytics Sentry Error logging StatusPage Status page