Well, SQL Developer is a client tool, so whilst it can import and export CSV data (often mistaken as being Excel data, though Excel can read/write CSV) it's not usually an appropriate tool to be using for scheduled tasks like that.
In that case you probably want to create your own code to export the CSV data (or you could export it in Office XML format if you really want Excel formatting in there).
Have a look at the links in the FAQ over in the SQL and PL/SQL forum...
Could you suggest an appropriate scheduling tool (if there is such a thing)?
Oracle has a DBMS_SCHEDULER package (or the older DBMS_JOB package) where you can set up jobs/schedules in a variety of ways.
You can also created scheduled jobs through Enterprise Manager if you have access to that.
You can use our command line interface to export the contents of a Cart to Excel files.
You start by creating your cart - drag your tables/views there. Then you setup your Export action - you'd set to data only, target to Excel, multiple files.
Then you'd feed that to the sdcli program in the SQL Developer/install BIN folder.
I talk about the cart here.
I talk about sdcli here.
This will work just fine if we're talking about reasonable amounts of data. If you're talking about very large tables, you'll want to code something in PL/SQL and use database jobs.
Interesting, I wasn't aware of the 'cart' (don't use SQL Developer that often). Odd concept having the tool act like a shopping trip.
I'll give this one a go - and let you know. As mentioned I'm new to developer and PL/SQL so it might take a while
you add things to your cart, and you upload them to the 'cloud' - that was the original use case
now we let you add objects and run operations against said objects, like a db diff, export, db copy...