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