Export the content of the ADF table to excel

Overview

In general application development, especially enterprise-level application development, you often need to develop reports. In the ADF, you can export the content in the Table in Excel, this document describes how to export table content to excel in the ADF.

Implementation

1. Create an ADF application. Create entity object and view object based on the departments table in the HR schema.

2. Create an application module and add the instance of the newly created view object to the data model.

3. Create a page, drag the instance of the view object from the Data Control Panel to the page, display the data as a table, and layout it. Add a panel collection layer outside the table, add a toolbar to the Panel collection, and then add a toolbar button.

 

4. In the toolbar labels, the structure and attribute settings after adding are respectively

5. Save and run the application

Run page:

Click the export button:

Open the saved file:

 

This article is transferred from Oracle Seeker: http://oracleseeker.com/2009/11/02/adf_table_export_excel/