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.

  • Memory optimization mode for writing large files.

It supports Python 2.5, 2.6, 2.7, 3.1, 3.2, 3.3, 3.4, 3.5, 3.6, 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: 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.0.7.tar.gz (246.3 kB view details)

Uploaded Source

Built Distribution

XlsxWriter-1.0.7-py2.py3-none-any.whl (142.9 kB view details)

Uploaded Python 2Python 3

File details

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

File metadata

  • Download URL: XlsxWriter-1.0.7.tar.gz
  • Upload date:
  • Size: 246.3 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/1.9.1 pkginfo/1.4.1 requests/2.18.4 setuptools/36.4.0 requests-toolbelt/0.8.0 tqdm/4.15.0 CPython/2.7.4

File hashes

Hashes for XlsxWriter-1.0.7.tar.gz
Algorithm Hash digest
SHA256 1224b971c174f33b954f9a1906679d0049399bd6a5a8c78bbae2d6c2c4facebd
MD5 04c88be21fac3c54b66cfb7689d7c207
BLAKE2b-256 9ec5159e901bf4017fca90dbd66aa1d9c7742417a2d22b2b8f0b5aefa1e058bd

See more details on using hashes here.

File details

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

File metadata

  • Download URL: XlsxWriter-1.0.7-py2.py3-none-any.whl
  • Upload date:
  • Size: 142.9 kB
  • Tags: Python 2, Python 3
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/1.9.1 pkginfo/1.4.1 requests/2.18.4 setuptools/36.4.0 requests-toolbelt/0.8.0 tqdm/4.15.0 CPython/2.7.4

File hashes

Hashes for XlsxWriter-1.0.7-py2.py3-none-any.whl
Algorithm Hash digest
SHA256 8b579aa9d45030e55e41c8e6f5ef5696fab8cbb25c9e9b49dc06948a994fc534
MD5 09dff9952844c9dae112253176aadb2b
BLAKE2b-256 9c201e74436ca169068ee239f5292f4912c3d4e572eb98d30ebd03f10c2b748e

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