XlsxWriter is a Python library for creating spreadsheet files in Excel 2007 (XLSX) format. This library has been developed by John McNamara. Its latest version is 3.0.2 which was released in November 2021. The latest version requires Python 3.4 or above.

Audience

This tutorial is meant for Python developers who are interested in programmatically automating the functionality of MS Excel software.

Prerequisites

Before proceeding with this tutorial, you should have an understanding of Python programming and proficiency in handling MS Excel of intermediate level. The knowledge of object oriented programming is desired but not essential.