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

Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

XlsxWriter-1.0.4.tar.gz (243.1 kB view details)

Uploaded Source

Built Distribution

XlsxWriter-1.0.4-py2.py3-none-any.whl (141.6 kB view details)

Uploaded Python 2 Python 3

File details

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

File metadata

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

File hashes

Hashes for XlsxWriter-1.0.4.tar.gz
Algorithm Hash digest
SHA256 ad947fd9e8edfb64f25e0ccfb161e109f279e5a5520b3dd22ddc03b7f8220887
MD5 fcc040e53dbdbc1e736bab803c1ca282
BLAKE2b-256 04c9d5a8b02561a32bfcbec767a7d094c1ce54874eba9bc6bbaa58dd9ad523e7

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for XlsxWriter-1.0.4-py2.py3-none-any.whl
Algorithm Hash digest
SHA256 86a55f62f783cda5b9b8ab71fb1a96c20b5d079fb88b3fcef6867e78af9f1dbd
MD5 857eaa379caf1d90c887dfc4cffecd5e
BLAKE2b-256 52c656228f8bece3e6d707c7ba3ffde839a8989ccbc07ca3c2021d1b8243ee2c

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