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


Step1.  创建Excel WorkBook

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


Step1. 设定Excel Workbook

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

Step3. 编辑参数,增加RowAction

Step4. 修改BatchOption,commit BactionAction





Thanks and Regards

最新文章

  1. C# 获取当前路径7种方法
  2. 点击表格tr同时点击checkbox
  3. C#:比较二个字符串,查找出相同字数和差异字符
  4. Hadoop2.6 datanode配置在线更新
  5. asp.net 运行时,"未能映射路径"
  6. 网络闪段致slave 出错分析
  7. EF容器---代理类对象
  8. var obj = {};var obj2 = [];var obj3;
  9. IP地址,子网掩码划分(转)
  10. JavaScript获取HTML DOM节点元素详解(转)
  11. h5 录音
  12. DataGridView的使用记录
  13. 从壹开始前后端分离【 .NET Core2.0 +Vue2.0 】框架之七 || API项目整体搭建 6.2 轻量级ORM
  14. WEB API 系列(二) Filter的使用以及执行顺序
  15. C++实现对文件中各单词词频的统计及其代码优化
  16. Python 爬虫 --- urllib
  17. abstract class 和 interface 区别
  18. camera理论基础和工作原理(转)
  19. Oracle 多表查询、查询运算符和集合运算
  20. Kubernetes学习之路(八)之Kubeadm部署集群

热门文章

  1. “LC.exe”已退出,代码为 -1
  2. guava学习--File1
  3. PDF 补丁丁 0.4.2.1013 测试版发布:修复替换PDF文档字体等问题
  4. mac系统xcode升级等软件更换appid账户
  5. GPS模块启动模式说明
  6. asp.net生成缩略图
  7. 在window上安装pandas
  8. asp.net与asp.net 优缺点
  9. source insight shift+tab问题
  10. (基础篇)echo、print、print_r、printf、sprintf、var_dump的区别比较