Skip to Main Content
Forums

Java Development Tools

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

I want to generate Excel report in ADF.

User_UKDN0Oct 6 2021

I want to generate the Excel report through Oracle ADF. I am converting oracle reports into adf reports. I had to re-write the whole sql query logic in ADF. The challange I am facing is , I am not able to generate the Excel reports in Oracle ADF, I am able to generate PDF reports.
Can someone help me how to generate the excel report in ADF from oracle reports?

Comments

dvohra21

BI Publisher could be used.
Refer blog How to integrate Oracle ADF with BI Publisher by JDeveloper 11g to Generate Reports
and blog :
Call Oracle Reports From Your ADF Application
Also refer related thread "Reports 12c - Export to excel"
"

There are various ways to export to excel - for example using POI library.
See some ideas here - https://pinboard.in/search/u:OracleADF?query=excel
Also - you might be interested in the ADF Desktop Integration solution that will let you connect Excel directly to the VOs.
https://www.oracle.com/database/technologies/developer-tools/adf/desktop-integration.html

1 - 2

Post Details

Added on Oct 6 2021
#application-development-in-java, #jdeveloper-and-adf
2 comments
320 views