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

This version

0.6.7

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

Uploaded Source

Built Distribution

XlsxWriter-0.6.7-py2.py3-none-any.whl (127.7 kB view details)

Uploaded Python 2Python 3

File details

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

File metadata

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

File hashes

Hashes for XlsxWriter-0.6.7.tar.gz
Algorithm Hash digest
SHA256 dd5c91c024391c24949735b50495de2caf0fff25691425863e048354993a878a
MD5 4f8ac473e338477352b16e1de0c4906d
BLAKE2b-256 e5e887736d8d8a47907ad16c354dafda657f207bbd027306ac31282ca4d9229d

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for XlsxWriter-0.6.7-py2.py3-none-any.whl
Algorithm Hash digest
SHA256 77458abfb91b1627a5745642a01d90e311abab1c08bf134feef41d72a4e9c2af
MD5 3b73a960d3c61db3e7b6c33da3aa37b9
BLAKE2b-256 8bc4a4a2ca84530e6d13c5a41285e6d22fcd1e3c4ce4196490c8fdaef72450c2

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