You can create a scheduler event and create a microflow by configuring the templates to export data from your Mendix application to the Excel, macro-enabled Excel, or CSV formats. And build a logic to export the generated excel file to a specific location.
To do this, you need to import the following modules :
Excel Exporter : https://marketplace.mendix.com/link/component/726
Mx Model Reflection : https://marketplace.mendix.com/link/component/69