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+, 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.1.9.tar.gz (254.5 kB view details)

Uploaded Source

Built Distribution

XlsxWriter-1.1.9-py2.py3-none-any.whl (139.9 kB view details)

Uploaded Python 2Python 3

File details

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

File metadata

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

File hashes

Hashes for XlsxWriter-1.1.9.tar.gz
Algorithm Hash digest
SHA256 1a49d3b0bd70eff9641aed131f39de65cc7cb626af11d2c30200a86fb33dd109
MD5 fce04054516aea40d3ff10761f0522b2
BLAKE2b-256 aac60f32f36644b105581aad7e4151e6efed4e61a69fa9065a5a41708e128d1c

See more details on using hashes here.

File details

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

File metadata

  • Download URL: XlsxWriter-1.1.9-py2.py3-none-any.whl
  • Upload date:
  • Size: 139.9 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/40.2.0 requests-toolbelt/0.8.0 tqdm/4.25.0 CPython/2.7.15

File hashes

Hashes for XlsxWriter-1.1.9-py2.py3-none-any.whl
Algorithm Hash digest
SHA256 37026a50342b248e38606f52a7cd213d4cbc7adc008d5667c93d53262bde6506
MD5 3555e8722d46d1e40158fc3bbda5c447
BLAKE2b-256 080301078c133704b7545949ed98cbd888db100f0672f8333a03218f49f9d959

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