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 optimisation 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.7.7.tar.gz (232.6 kB view details)

Uploaded Source

Built Distribution

XlsxWriter-0.7.7-py2.py3-none-any.whl (133.3 kB view details)

Uploaded Python 2 Python 3

File details

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

File metadata

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

File hashes

Hashes for XlsxWriter-0.7.7.tar.gz
Algorithm Hash digest
SHA256 33a6fac3b148ab6137a7e2c0869e33493aff5ccde66e434c1ccf49e8687b9606
MD5 c68dca16927e2a919837c68ff63b1e5b
BLAKE2b-256 9899c58683614a8723e9a590b59bd30689dbe7d5000228e6ca7de06a87192321

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for XlsxWriter-0.7.7-py2.py3-none-any.whl
Algorithm Hash digest
SHA256 f53d52f983cd13c4030249aac01ebe0e8d8100a7aa429c89c4c8585bb3d76b93
MD5 941ece38f628f3f87d2a9e41f8818804
BLAKE2b-256 b969bd1309a9de3661e02b3094348a063960dfb21f82873bda5a6c39bfb52340

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