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 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, 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.9.1

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.9.1.tar.gz (236.9 kB view details)

Uploaded Source

Built Distribution

XlsxWriter-0.9.1-py2.py3-none-any.whl (136.9 kB view details)

Uploaded Python 2 Python 3

File details

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

File metadata

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

File hashes

Hashes for XlsxWriter-0.9.1.tar.gz
Algorithm Hash digest
SHA256 aad187c7d1d483aae89439d0bfe499755f473fca13eb1d06f156bc3bb0ff3fd5
MD5 091f44cb2d2efc8a43821cf956372fd9
BLAKE2b-256 1d6bcdedb14c71c524861e7a44bee785403a0c84cbb87f5640836ec3f55ca805

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for XlsxWriter-0.9.1-py2.py3-none-any.whl
Algorithm Hash digest
SHA256 3fd46f38ae47d0d622ca3a252d424c3a5602d1782bac8e40f4c9a707447ab2b3
MD5 d4caea8070fccf6a7d81eaa521bd2bec
BLAKE2b-256 b03dc443388c59de4f0d2c87fd541ab7117626ea651bc02c5c231976434d3b2a

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