I have to make 2 business-like reports about media. Therefore I have to analyze data and give colleagues an excel file with multiple custom formatted tables. 
Is there a way to make custom formatted tables in R or python and export them to excel? 
This way I can automate formatting the 3000+ tables :) 
Thanks in advance!
Have you tried using pandas ? In python.
How to export custom tables from R/Python to Excel?