Skip to main content

A Python module for creating Excel XLSX files.

Project description

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()
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

Project details


Release history Release notifications | RSS feed

This version

3.1.3

Download files

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

Source Distribution

XlsxWriter-3.1.3.tar.gz (270.2 kB view details)

Uploaded Source

Built Distribution

XlsxWriter-3.1.3-py3-none-any.whl (153.2 kB view details)

Uploaded Python 3

File details

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

File metadata

  • Download URL: XlsxWriter-3.1.3.tar.gz
  • Upload date:
  • Size: 270.2 kB
  • Tags: Source
  • Uploaded using 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.18

File hashes

Hashes for XlsxWriter-3.1.3.tar.gz
Algorithm Hash digest
SHA256 696c16458d50712a3a5f902676c045ddb4c1bd1b54595f501e582d549abdbdb9
MD5 016a38c14d8ce03193d507b13b767355
BLAKE2b-256 a4840e28778dd6d6871c1b3f4c99edaa0ab346d730c87f66498df6ea00e29d4d

See more details on using hashes here.

File details

Details for the file XlsxWriter-3.1.3-py3-none-any.whl.

File metadata

  • Download URL: XlsxWriter-3.1.3-py3-none-any.whl
  • Upload date:
  • Size: 153.2 kB
  • Tags: Python 3
  • Uploaded using 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.18

File hashes

Hashes for XlsxWriter-3.1.3-py3-none-any.whl
Algorithm Hash digest
SHA256 b1fde9b60dc25fff589f3baf58e95178048ba87a7916d45f6e3bce4a61f56e64
MD5 df8112bb10e23bc146bb24057f66c40e
BLAKE2b-256 6a8c5982a902521519d3f671bd24bce63eda474d7f16502c78ac2bb5ab889aa0

See more details on using hashes here.

Supported by

AWS Cloud computing and Security Sponsor Datadog Monitoring Fastly CDN Google Download Analytics Pingdom Monitoring Sentry Error logging StatusPage Status page