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

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

Uploaded Source

Built Distribution

XlsxWriter-0.8.0-py2.py3-none-any.whl (134.7 kB view details)

Uploaded Python 2 Python 3

File details

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

File metadata

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

File hashes

Hashes for XlsxWriter-0.8.0.tar.gz
Algorithm Hash digest
SHA256 6ad16fcea6602404da4ced2d029431407735d08d20a16c9c5c7ff451d2a475db
MD5 7765c5dc7f4c346f23f0fbbafaad7667
BLAKE2b-256 fc2524858731942ee704c721d4dc9f8854fd2a186e3e808d35ba453f90a3269e

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for XlsxWriter-0.8.0-py2.py3-none-any.whl
Algorithm Hash digest
SHA256 c740beb4caa42f4b8f97cf50584069776fe0216985beb8e3f418b3bb27a81400
MD5 31375a9fa534178f6ac6560b67b023c8
BLAKE2b-256 0ab3bc4630c824a7f5b63313c8a9e2bc11613dde795e781ebf06d2debc80b9cd

See more details on using hashes here.

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page