Exporting table data into Excel File in ADF

Here’s the quickest way of exporting table data into Excel File :

1) Create Model using Business Components and refresh Data Controls.
2) Create a standard and JSF page and drag-drop the control the data control to create a ADF table. Name the ID of the table as t1.
3) Create a Command Button and change the text to “Export”.
4) Refer to the snapshot below :

5) Drag-Drop Export Collection Action Listener onto the Command Button “Export”.
6) Set the following Configurations for bindings :

ExportedId : t1
Type : excelHTML

7) Set the Filename and Title in the property inspector of Export Collection Action Listener.
8) Run the page.

Author- Ankit Gupta

happy coding with Techartifact.


I am an Oracle ACE in Oracle ADF/Webcenter. Sr Java Consultant-working on Java/J2EE/Oracle ADF/Webcenter Portal/ content and Hibernate for several years. I'm an active member of the OTN JDeveloper/Webcenter forum. Passionate about learning new technologies. I am here to share my knowledge. Give your views and suggestion on [email protected] .

More Posts - Website

Follow Me:
TwitterLinkedInGoogle PlusYouTube