logobossness

• Export Oracle Report To Excel
• Oracle Apex Plugins

Export your Interactive Reports/Grids to Excel. The 'GPV Interactive Report/Grid to MSExcel' APEX plugin lets you get results of your Interactive Report or Interactive Grid in Excel-format, with correct displaying of Strings, Number and Dates. Filtering and Sorting. Control Breaks.

I want to export the Interactive Grid data into an excel. How can I do that. In the download option in Actions tab, it only has csv and HTML option. Can we add an option there to download the report in excel. Or can we add a button separtely, on click of which the report can be downloaded in xls.

Thanks,Abha

Export Oracle Report To Excel

2 Answers

Oracle Apex Plugins

CSV is Excel. Not a true MS Excel file (i.e. XLS or XLSX), but - Excel opens a Comma-Separated-Values file without any problems.

So - export as CSV, open with Excel. Should be just fine.

LittlefootLittlefoot

Yes, interactive reports and grids support exporting to native Excel (xlsx), as well as Word (rtf) and PDF.

To enable this there are multiple options:

• Oracle BI Publisher
• FOP (ORDS)
• APEX Office Print (AOP)

Once you have configured the print server (this is an APEX instance-wide setting), you can then enable the output options in your IR or IG regions.

https://insum.ca/oracle-apex-printing-options/(note: I'm not sure that all the other printing options mentioned in this link support interactive reports or grids)

Jeffrey KempJeffrey Kemp

Not the answer you're looking for? Browse other questions tagged oracle-apex or ask your own question.

The packages for Export to Excel for ApEx and XE are now unwrapped and available for download:
http://htmldb.oracle.com/pls/otn/f?p=31517:108
http://htmldb.oracle.com/pls/otn/f?p=31517:109
You may use them and modify as you need. It has been downloaded arround 300 times in the last two months. Shows that it works and it is needed, despite of the new BI publisher feature available for ApEx 3.0.
The method is quite simple. You need to generate HTML tables and it will be readable as a normal .xls file from 97 to the latest version. This gives an option to create multiple pages in excel and export multiple reports in one run as one file. Of course, it needs some modification within the package to do that.
Have fun.