Creating Excel files with Python and XlsxWriter#
XlsxWriter is a Python module for creating Excel XLSX files.
(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.
- Working with Cell Notation
- Working with and Writing Data
- Working with Formulas
- Working with Dates and Time
- Working with Colors
- Working with Charts
- Working with Object Positioning
- Working with Autofilters
- Working with Data Validation
- Working with Conditional Formatting
- Working with Worksheet Tables
- Working with Textboxes
- Working with Sparklines
- Working with Cell Comments
- Working with Outlines and Grouping
- Working with Memory and Performance
- Working with VBA Macros
- Working with Pandas and XlsxWriter
- Working with Polars and XlsxWriter