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:
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.
This document explains how to use the XlsxWriter module. See the following sections for more information, or jump straight to the Introduction.