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/BMP/WMF/EMF 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, 3.6, 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.5.tar.gz (245.4 kB view details)

Uploaded Source

Built Distribution

XlsxWriter-1.0.5-py2.py3-none-any.whl (142.2 kB view details)

Uploaded Python 2Python 3

File details

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

File metadata

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

File hashes

Hashes for XlsxWriter-1.0.5.tar.gz
Algorithm Hash digest
SHA256 bd4661c04a68621cb2ebc07c38b8b2e98e30bf213a16e1cf3675b61e26ca9bf2
MD5 0fa86d5af48873bc8f8d6c45c7dee2be
BLAKE2b-256 1b8953e57e1e873c6396231827bdab94423a2371662f59f062af09664b902929

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for XlsxWriter-1.0.5-py2.py3-none-any.whl
Algorithm Hash digest
SHA256 05005a069da3fcadeb20ff9384d92e548096faf9ede9d6a538403fa8e0aae1f0
MD5 6946a485a9caad1d7a91de457ef88048
BLAKE2b-256 3350136b801d106fcebb2428a764e5c599e020d8227a3623db078e05eb4793a5

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