Generate automated reports from influxdb

Is there a way I can generate reports from Influxdb in excel format periodically and is automated.?

Can grafana do the same? Generate reports of dashboard monthly or periodically and this process needs to be automated.

Currently no. The logic for exporting to CSV is in JavaScript and is not in the API and is not connected to a url/route.

You could do it using PhantomJS/Selenium to login and click buttons or send a Pull Request to add a frontend route to Grafana that exports CSV for a panel (with querystring parameters for as rows/columns and the date format).