当前位置: 代码迷 >> Oracle管理 >> ADF_Desktop Integration系列3_ADF圆桌面集成入门之重定义ADF Desktop Excel
  详细解决方案

ADF_Desktop Integration系列3_ADF圆桌面集成入门之重定义ADF Desktop Excel

热度:349   发布时间:2016-04-24 04:06:33.0
ADF_Desktop Integration系列3_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.  创建Excel WorkBook

Step2. 进行Data Binding,查看可以帮的Component

 

2: Creating the DepartmentsList Workbook 


Step1. 设定Excel Workbook

Step2.  简单测试运行,页面正常,但是并无数据

Step3. 编辑参数,增加RowAction

Step4. 修改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

  相关解决方案