Style Excel Files using Python 3 (xlsxwriter) | Automate Excel #3

In this python3 tutorial, I'll show you how to add styling to the Excel Files (.xlsx) that you created with xlsxwriter.

[dabody]

bro where the link for decimate for xlrd

[wheelie]

Clear explanation of how to do this, but your explanation on formatting after writing is technically incorrect. Python does not go back to change the already written cells, that happens because the library matches the excel file format.

Xlsx files dont store formatting per cell. They store 'formatting objects'and cells reference these formatting objects. If you change the formatting object at any point the cells will still reference this object and reflect that change. Knowing that you don't pass formatting to a cell but a reference helps explain the code behaviour.