Learning Python for Forensics

Creating spreadsheets with the xlsxwriter module

Xlsxwriter (version 0.7.6) is a useful third-party module that writes the Excel output. 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

Adding data to a spreadsheet

Let's quickly create a script named simplexlsx.v1.py for this example. On lines 1 and 2, we import the xlsxwriter and datetime modules. The data we are going to be plotting, including the header column, ...