Creating spreadsheets with the xlsxwriter module

xlsxwriter (version 1.1.2) is a useful third-party module that can write data to Excel spreadsheets. There are a plethora of Excel-supported modules for Python, but we chose this module because it was highly robust and well-documented. As the name suggests, this module can only be used to write Excel spreadsheets. The xlsxwriter module supports cell and conditional formatting, charts, tables, filters, and macros, among others. This module can be installed with pip:

pip install xlsxwriter==1.1.2 

Adding data to a spreadsheet

Let's quickly create a script named simplexlsx.v1.py for this example. On lines 2 and 3, we import the xlsxwriter and datetime modules. The data we...