Creating Excel files with Python and XlsxWriter#

XlsxWriter is a Python module for creating Excel XLSX files.

_images/demo.png

(Sample code to create the above spreadsheet.)

XlsxWriter

XlsxWriter is a Python module that can be used to write text, numbers, formulas and hyperlinks to multiple worksheets in an Excel 2007+ XLSX file. 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.

  • Textboxes.

  • Integration with Pandas and Polars.

  • Memory optimization mode for writing large files.

It supports Python 3.4+ and PyPy3 and uses standard libraries only.

This document explains how to use the XlsxWriter module. See the following sections for more information, or jump straight to the Introduction.