We help IT Professionals succeed at work.

Oracle batch extract into xlsx format

Hi all

Each week, i'm extracting into xlsx format about 20 custom queries.

Manually, it takes a lot of time. I only have a limited access to the tables and i'm also using Oracle SQL Developper version 4.0.3.16.

I have all my custom queries under the Reports / All Reports and under User Defined Reports.

How can i pull all the queries so that it automatically extract into xlsx format in a folder?

Is this even possible?

Thanks for your help.
Comment
Watch Question

Most Valuable Expert 2012
Distinguished Expert 2019
Commented:
I don't believe SQL Developer has a way to automate this.

You can automate the creation of a CSV file or you can write your own program.

Using .Net with OpenXML APIs it is pretty easy to generate native xlsx spreadsheets.
Thanks for the idea. I will look at this option.