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

Uploaded Source

Built Distribution

XlsxWriter-0.8.9-py2.py3-none-any.whl (136.7 kB view details)

Uploaded Python 2Python 3

File details

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

File metadata

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

File hashes

Hashes for XlsxWriter-0.8.9.tar.gz
Algorithm Hash digest
SHA256 cb90c5283b88af72549adf82f203d15623a0f4faeae29b6a20733e187dfde882
MD5 545c938f279abcfd7f11e705012302fe
BLAKE2b-256 2ade4ee20ac103417662865e0e3acde859b002c13f52af0d50a2664d3eca5897

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for XlsxWriter-0.8.9-py2.py3-none-any.whl
Algorithm Hash digest
SHA256 f9484e884768bcff518ef31b6a17b4cf3581f1d7349646e0d98685823cd2dd27
MD5 e58eb67ce21b9f3dd0c3be848ea0d7ee
BLAKE2b-256 4ef230f50cc387de56c07f8b93221bd627ffaa18c0adb14236648c572bca98f5

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