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
Step1. 创建Excel WorkBook
Step2. 进行Data Binding,查看可以帮的Component
Step1. 设定Excel Workbook
Step2. 简单测试运行,页面正常,但是并无数据
Step3. 编辑参数,增加RowAction
Step4. 修改BatchOption,commit BactionAction
Thanks and Regards
最新文章
- C# 获取当前路径7种方法
- 点击表格tr同时点击checkbox
- C#:比较二个字符串,查找出相同字数和差异字符
- Hadoop2.6 datanode配置在线更新
- asp.net 运行时,";未能映射路径";
- 网络闪段致slave 出错分析
- EF容器---代理类对象
- var obj = {};var obj2 = [];var obj3;
- IP地址,子网掩码划分(转)
- JavaScript获取HTML DOM节点元素详解(转)
- h5 录音
- DataGridView的使用记录
- 从壹开始前后端分离【 .NET Core2.0 +Vue2.0 】框架之七 || API项目整体搭建 6.2 轻量级ORM
- WEB API 系列(二) Filter的使用以及执行顺序
- C++实现对文件中各单词词频的统计及其代码优化
- Python 爬虫 --- urllib
- abstract class 和 interface 区别
- camera理论基础和工作原理(转)
- Oracle 多表查询、查询运算符和集合运算
- Kubernetes学习之路(八)之Kubeadm部署集群
热门文章
- “LC.exe”已退出,代码为 -1
- guava学习--File1
- PDF 补丁丁 0.4.2.1013 测试版发布:修复替换PDF文档字体等问题
- mac系统xcode升级等软件更换appid账户
- GPS模块启动模式说明
- asp.net生成缩略图
- 在window上安装pandas
- asp.net与asp.net 优缺点
- source insight shift+tab问题
- (基础篇)echo、print、print_r、printf、sprintf、var_dump的区别比较