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/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 2.7, 3.4+ 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: https://xlsxwriter.readthedocs.io

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

Project details


Release history Release notifications | RSS feed

Download files

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

Source Distribution

XlsxWriter-1.3.5.tar.gz (255.1 kB view details)

Uploaded Source

Built Distribution

XlsxWriter-1.3.5-py2.py3-none-any.whl (144.3 kB view details)

Uploaded Python 2Python 3

File details

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

File metadata

  • Download URL: XlsxWriter-1.3.5.tar.gz
  • Upload date:
  • Size: 255.1 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/1.11.0 pkginfo/1.4.2 requests/2.19.1 setuptools/41.4.0 requests-toolbelt/0.8.0 tqdm/4.25.0 CPython/2.7.17

File hashes

Hashes for XlsxWriter-1.3.5.tar.gz
Algorithm Hash digest
SHA256 de54547f3aa1a611453e32a8ae46380edb5556e823c6803f8673b4b770e50b3b
MD5 0b65976905bf3841bc6cae3f8c47295b
BLAKE2b-256 b89de7bba3f52b30befdf0910c1a228ea1222bd08866f029b56d9e86f12ab75a

See more details on using hashes here.

File details

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

File metadata

  • Download URL: XlsxWriter-1.3.5-py2.py3-none-any.whl
  • Upload date:
  • Size: 144.3 kB
  • Tags: Python 2, Python 3
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/1.11.0 pkginfo/1.4.2 requests/2.19.1 setuptools/41.4.0 requests-toolbelt/0.8.0 tqdm/4.25.0 CPython/2.7.17

File hashes

Hashes for XlsxWriter-1.3.5-py2.py3-none-any.whl
Algorithm Hash digest
SHA256 3886909f8bcd58d432097044d411b9236761cd7711ebb8c0b8971157899dce25
MD5 2442df8c3321a1a2ac68d9c2c9cff9dc
BLAKE2b-256 397d239b21bf79f403edf8522c0692acd0f98e1a0f66e7a1485ff75f95564f5b

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