Adf_desktop Integration Series 1_ADF Desktop Integration Settings development environment

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:enable Microsoft. Net Programmability Support

Step1. Confirm that the machine is installed Microsoft.NET

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

Step1. Installing the ADF 11g Desktop integration

STEP.2 now complete, do a custom installation

Step3. Installation Complete

3:configure Excel to Run an Integrated Excel Workbook

Step1. Set Excel macro settings to start a macro

4:load the Startup Fusion Web application

Step1. After the ADF desktop is installed, download ADFDI_BC and import the application because the business Component of the test data exists in the package

Step2. To view the open ADF download package application

5:check the application ' s Database Connection

Step1. Creating a DB Connection  

Step2. Run the test am to see if the data is healthy

Thanks and regards

Reference: Oracle-oracle JDeveloper 11g Release 2 Tutorials

Adf_desktop Integration Series 1_ADF Desktop Integration Settings development environment