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.

  • 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.4.3.tar.gz (269.9 kB view details)

Uploaded Source

Built Distribution

XlsxWriter-1.4.3-py2.py3-none-any.whl (149.4 kB view details)

Uploaded Python 2 Python 3

File details

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

File metadata

  • Download URL: XlsxWriter-1.4.3.tar.gz
  • Upload date:
  • Size: 269.9 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.4.3.tar.gz
Algorithm Hash digest
SHA256 641db6e7b4f4982fd407a3f372f45b878766098250d26963e95e50121168cbe2
MD5 15bc70a372e6b2dcad24f9fdd7ebe9c3
BLAKE2b-256 844989b391cf924c52e8003d9b7de1b2214441fd50c3bbe4b2ae0d81f5820379

See more details on using hashes here.

File details

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

File metadata

  • Download URL: XlsxWriter-1.4.3-py2.py3-none-any.whl
  • Upload date:
  • Size: 149.4 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.4.3-py2.py3-none-any.whl
Algorithm Hash digest
SHA256 1a7fac99687020e76aa7dd0d7de4b9b576547ed748e5cd91a99d52a6df54ca16
MD5 cf87f717b663fde31637625bbff7ee12
BLAKE2b-256 2cce74fd8d638a5b82ea0c6f08a5978f741c2655a38c3d6e82f73a0f084377e6

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