CODEWITHSUNDEEP
oracle-apexoracle-apex-19.1
Ani
Ani

Reputation: 5

Hi, Using Oracle Apex 19.1, I have a requirement of downloading data into excel as multiple tabs

.Each interactive report data should come in each tab(i.e) sheet1, sheet2....
Example: In Apex page, I have 5 report region. Each report data should be downloaded in each sheet, In a single excel file.Please provide me a solution, Thanks in advance Karthick.

Upvotes: 0

Views: 1184

Answers (1)

Salim Hlayel
Salim Hlayel

Reputation: 371

If you cannot upgrade your APEX environment then, as TineO said, probably AOP is the best option you have.

If you can upgrade to 19.2 or higher, then you can utilize APEX_REGION.OPEN_QUERY_CONTEXT API to get the records of the interactive reports. Then, you can use the Open Source library Alexandria and in particular, the xlsx_builder_pkg package to create the spreadsheets.

Upvotes: 0

Related Questions