Let’s say you have to repeatedly prepare some reports with the same structure. Wouldn’t it be great if you can automatically generate them once you have the data? Well, actually you can!
Microsoft changed the underlying structure of their Office documents (Word, Powerpoint, Excel, etc.) from binary to Open-XML with the release of Microsoft Office 20071. Take a guess what the
x in the new extensions
.xlsx stands for. This offers a few advantages, including the most notable one of making the format open and accessible for anyone. We will be taking advantage of this to generate Word reports from templates with Python.