Fuck python Excel libraries. Had to write a spreadsheet formatting/filtering script to automate content generation. Definition of too much work. On the plus side just auto formatted 5000 spreadsheets in seconds.

VBA wouldn't work here?

fam I know your struggle. I had to create an excel generator, and I found the C# lib we used to generate CSV did not support dynamic columns. I had to format each cell individually, and heavily abuse array class methods in a way that made me feel dirty afterwards.

@fredrf it would have, though I'm not nearly as familiar.
It was just a poorly documented library and I was under a deadline. Shouts out to xlwt, and xlrd and whoever made them, I'm over it. Add excel files to the list of things I can bend to my will.