ADF_Desktop Integration系列2_ADF圆桌面集成入门之开发简单ADF Desktop Excel

2013-05-01 Created By BaoXinjian

一、摘要

本教程介绍开发一个简单的Excel WorkSheet并与Fusion Web Application进行整合，将页面转换为Desktop Excel用以用户上传资料

案例目的：创建一个Query ExcelWorksheet用以查询Employee，创建一个Query/Update/Delete Excel Worksheet用以增删改Department

案例描述如下：

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. 创建Microsoft Excel WorkBook 

Step2. 查看所创建的Excel 

Step3. 进行Data Binding时，选择数据来源PageDefinition 

Step4. 查看页面对应的Page Definition文件 

Step5. 查看Data Binding的数据Component 

 Step6. 查看Data Binding时的属性参数

Step7. 查看页面中的数据布局情况

Step8. 查看数据Java EE Application 

Step9. 设定Excel的Workbook和WorkSheet属性 

Step10. 创建Download菜单项的Event 

Step11. 创建Download菜单项的Action 

2: Testing the DepartmentsList Workbook

Step1. 测试运行页面的测试结果

Step2. 测试运行Excel，显示数据，进行Validate 

Step3. 测试运行Excel，运行结果

Thanks and Regards 

参考：Oracle - Oracle JDeveloper 11g Release 2 Tutorials