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 images.

  • Rich multi-format strings.

  • Cell comments.

  • Integration with Pandas.

  • Textboxes.

  • Memory optimisation mode for writing large files.

It supports Python 2.5, 2.6, 2.7, 3.1, 3.2, 3.3, 3.4, 3.5, 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: http://xlsxwriter.readthedocs.org

Release notes: http://xlsxwriter.readthedocs.org/changes.html

Project details


Release history Release notifications | RSS feed

This version

0.7.6

Download files

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

Source Distribution

XlsxWriter-0.7.6.tar.gz (232.5 kB view details)

Uploaded Source

Built Distribution

XlsxWriter-0.7.6-py2.py3-none-any.whl (133.2 kB view details)

Uploaded Python 2Python 3

File details

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

File metadata

  • Download URL: XlsxWriter-0.7.6.tar.gz
  • Upload date:
  • Size: 232.5 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? No

File hashes

Hashes for XlsxWriter-0.7.6.tar.gz
Algorithm Hash digest
SHA256 8d32569e49c7a7e53ca26fc34e11897c80ebc94b86c4b9cc3f467d8d99cf5c64
MD5 251ecfe3e80c7f04cb750efbab808514
BLAKE2b-256 d316f527cf39168b5cca2d3132387b3e1a88ca2c5b74808c33919c8a44d77eaa

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for XlsxWriter-0.7.6-py2.py3-none-any.whl
Algorithm Hash digest
SHA256 2c04bf4757ae59fde6e8eb986c4b301918ee824f40838e0c6bf2febcca01c501
MD5 9a4174a387e623746eda88ef725e1928
BLAKE2b-256 b1089fe3631004afa7b13fa4a59b03300e916bfa7bac85bfcb6379369201370e

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