Ability to download Salesforce report to an excel via scheduler

I need some sort of python code or api code to download Salesforce reports to an excel file in shared folder. Users dont want to manually download every day, hence we were asked to build some batch program to download the reports automatically to an excel file.