Home/Questions/Q 5389
In Process
Vard
Vard

Vard

View Profile
  • 1
Contributor
Asked: 2021-02-16T09:21:57+05:30

How to Generate Multi-Sheet Excel Export From Oracle APEX with Bi-Publisher

  • 1

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

question

    5 Answers

    1. Vinish

      Vinish

      View Profile
      Legendary

      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

       

      • 2
    2. Vard

      Vard

      View Profile
      Contributor

      Hi Vinish,

      Thank you for the reply.

      But I'm still a little confused on how to achieve this in APEX.

      1. Can I create RTF file on Microsoft Word or I need special plugin (or external program) to create one
      2. If I need my excel output in 3 different sheets in on excel spreadsheet do I need to create 3 different Source Queries in APEX Report Query Section
      3. Do I Need to use the RTF file in Report Layout section when I create a new layout
      4. Do I need to make any changes in APEX Report Layout xml section ( I have been using Generic Layout for the simple exports)

      I would really appreciate, if you can provide me with a simple example on how would the set up look like.

      Thank you,

      Vard

       

      • 0
    3. Vard

      Vard

      View Profile
      Contributor

      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

      • 1

    You must login to add an answer.