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: https://xlsxwriter.readthedocs.io

Release notes: https://xlsxwriter.readthedocs.io/changes.html

Project details


Release history Release notifications | RSS feed

This version

0.9.9

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

Uploaded Source

Built Distribution

XlsxWriter-0.9.9-py2.py3-none-any.whl (138.1 kB view details)

Uploaded Python 2Python 3

File details

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

File metadata

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

File hashes

Hashes for XlsxWriter-0.9.9.tar.gz
Algorithm Hash digest
SHA256 9ae87f451ee28fc229dbdc74ec3d55b4d0ebcd470ec37bfe33a56e82dea1ce35
MD5 f4c3077a54c5677a5689bb7fdca0d3d1
BLAKE2b-256 22fd64c1f125299de4f3dcb915ad87b00eff2a64f94cc11671fee053d08974df

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for XlsxWriter-0.9.9-py2.py3-none-any.whl
Algorithm Hash digest
SHA256 647b623a4650d8bb3188a0742936df0cff031974391d311d09731f537c03e812
MD5 bf594e2cbd41e1cd9bd913d7d816aed4
BLAKE2b-256 58f48c063bdb30c932914d3e511a1d87ef101264f5551577533d91f0188bd806

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