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.

  • Memory optimisation mode for writing large files.

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

Release notes: http://xlsxwriter.readthedocs.org/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-0.6.5.tar.gz (221.2 kB view details)

Uploaded Source

Built Distribution

XlsxWriter-0.6.5-py2.py3-none-any.whl (127.5 kB view details)

Uploaded Python 2 Python 3

File details

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

File metadata

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

File hashes

Hashes for XlsxWriter-0.6.5.tar.gz
Algorithm Hash digest
SHA256 cba7b4bb922388e23b81f99346589d5f63f1391c244c871e4a20e60d8b545c4b
MD5 7d58c3a4684ea79b9e5cbeee7f9240b0
BLAKE2b-256 5dfa417df202a3dc8f9a298a24d93bdd2a97e4e2ae078e1d60fc9d23cf685ae4

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for XlsxWriter-0.6.5-py2.py3-none-any.whl
Algorithm Hash digest
SHA256 9db7c534b9562e46a70f13061bfd584e191b3a2d6d27f683e2426557ca4d0b20
MD5 c8073046b7bbec9aa8649fd9c6689b30
BLAKE2b-256 f5845f0142f13a33f2362bf229b9daa377f7d8b68d6c62f24bea544e92a6d2f2

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