Hi,
Can you provide an example or point me to some good documentations on how to generate Multi-Sheet output in a single excel spreadsheet from Oracle Apex application by a click of a button.
I'm using APEX 19.2 (upgrading to 20.2 soon) and Bi-Publisher 12c.
Thank you =,
Varduhi
Vinish Kapoor
You can create an RTF template with multiple pages having different queries output, but each page should be separated by page break (Ctrl+Enter).
Then BI publisher will treat that each page as a separate sheet in Excel output. For in-depth details, please read the following article:
Multi sheet Excel Output using BI Publisher
Vard
Hi Vinish,
Thank you for the reply.
But I'm still a little confused on how to achieve this in APEX.
I would really appreciate, if you can provide me with a simple example on how would the set up look like.
Thank you,
Vard
Vinish Kapoor
The following are my answers:
I will soon write a tutorial on it and then will share it with you.
Vard
Hi Vinish,
Thank you for the reply and looking forward to seeing your tutorial. Your tutorials and blog posts are usually very in depth and helpful!
I don't have Bi-Publisher installed on my Windows. We are using Bi-Publisher that came installed by default with Oracle Cloud Control and it runs a server that does not have MS Word installed.
I tried to install B-Publisher locally, but the installation fails because I don't have the correct version of WebLogic Server.
Do you know any other ways or tools I can utilized to create TRF files without the need to install Bi-Publisher.
Thank you so much!
Vard
Vinish Kapoor
I have suggested you to install BI publisher to get the add-on for MS Word installed on your computer so that you can create RTF reports. There is no need for MS Word on the server.
Also, there is no need for a BI publisher on your local computer because it is already installed on a server or cloud. But you will have to install it on your local computer to get the add-on.
After creating RTF files, you would upload them in Apex > Shared Components > Report layout.
girlrobot
Did you ever get around to making this tutorial?