Is there a software or app that will be able to get data from my MySQL database, based on the same query every day (e.g.
select name from table where bla bla), write that data to a XLS file (not CSV), and store that file in a directory?
I've looked around online, but can't find pre-built software, only code and scripts that I have to write myself, and I'm not a developer.
I'm looking for something automated, I guess, like cron, but with the ability pull and output the data as an XLS file (not CSV, this is a must). Either Window or Linux.
Any help would really be appreciated.