Adf_desktop Integration Series 3_ADF Desktop integration redefined ADF desktop Excel

2013-05-01 Created by Baoxinjian

I. Summary

This tutorial introduces the development of a simple Excel worksheet and integrates with Fusion WEB application to convert the page to desktop Excel for users to upload data

Case PURPOSE: Create a query Excelworksheet for querying the employee, create a query/update/delete Excel worksheet to delete and modify department

The case description is as follows:

Part 1:configuring the environment to support Desktop integration

Step 1:enable Microsoft. Net Programmability Support

Step 2:install the Oracle ADF 11g Desktop integration add-in for Excel

Step 3:configure Excel to Run an Integrated Excel Workbook

Step 4:load the Startup Fusion Web application

Step 5:check The application ' s Database Connection

Part 2:developing a simple ADF Desktop integration-enabled Excel Workbook

Step 1:creating the Departmentslist Workbook

Step 2:testing the Departmentslist Workbook

Part 3:developing A more refined ADF Desktop integration-enabled Excel Workbook

Step 1:creating the Editdept_lov Workbook

Step 2:setting Worksheet and Table Properties

Step 3:defining a Query Ribbon Command

Step 4:defining a Delete Rows Ribbon Command

Step 5:defining an Upload Ribbon Command

Step 6:testing the Editdept_lov Workbook

Part 4:publishing the Workbooks

Step 1:publishing the Departmentslist Workbook

Step 2:publishing the Editdept_lov Workbook

1:creating the Departmentslist Workbook

Step1. Create Excel WorkBook

Step2. For data Binding, see what you can do to component

2:creating the Departmentslist Workbook

Step1. Set Excel Workbook

Step2. Simple test run, page normal, but no data

Step3. Edit parameters, add rowaction

Step4. Modify Batchoption,commit bactionaction

3:creating the Departmentslist Workbook

4:creating the Departmentslist Workbook

5:creating the Departmentslist Workbook

6:creating the Departmentslist Workbook

Thanks and regards

Adf_desktop Integration Series 3_ADF Desktop integration redefined ADF desktop Excel