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/GIF/BMP/WMF/EMF images.

  • Rich multi-format strings.

  • Cell comments.

  • Integration with Pandas.

  • Textboxes.

  • Support for adding Macros.

  • Memory optimization mode for writing large files.

It supports Python 3.4+ and PyPy3 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

This version

3.0.2

Download files

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

Source Distribution

XlsxWriter-3.0.2.tar.gz (263.7 kB view details)

Uploaded Source

Built Distribution

XlsxWriter-3.0.2-py3-none-any.whl (149.9 kB view details)

Uploaded Python 3

File details

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

File metadata

  • Download URL: XlsxWriter-3.0.2.tar.gz
  • Upload date:
  • Size: 263.7 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/3.4.2 importlib_metadata/4.6.3 pkginfo/1.7.1 requests/2.21.0 requests-toolbelt/0.9.1 tqdm/4.62.0 CPython/3.9.6

File hashes

Hashes for XlsxWriter-3.0.2.tar.gz
Algorithm Hash digest
SHA256 53005f03e8eb58f061ebf41d5767c7495ee0772c2396fe26b7e0ca22fa9c2570
MD5 590cca56f400f34c279ebcf5f186701c
BLAKE2b-256 cc52336ea010eda5cc4246c2696fc8d679634b1cbe5971a5cc8c151c051f0b4b

See more details on using hashes here.

File details

Details for the file XlsxWriter-3.0.2-py3-none-any.whl.

File metadata

  • Download URL: XlsxWriter-3.0.2-py3-none-any.whl
  • Upload date:
  • Size: 149.9 kB
  • Tags: Python 3
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/3.4.2 importlib_metadata/4.6.3 pkginfo/1.7.1 requests/2.21.0 requests-toolbelt/0.9.1 tqdm/4.62.0 CPython/3.9.6

File hashes

Hashes for XlsxWriter-3.0.2-py3-none-any.whl
Algorithm Hash digest
SHA256 1aa65166697c42284e82f5bf9a33c2e913341eeef2b262019c3f5b5334768765
MD5 c8e9737d740356541de6868631ff498f
BLAKE2b-256 cd84c239b08592a431f7ad8773f7869470255b5f1ad860d7b40a9e7ed3f01bde

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