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
技术交流,技术讨论,欢迎加入
Technology Blog Created By Oracle ERP - 鲍新建
【推荐】国内首个AI IDE,深度理解中文开发场景,立即下载体验Trae
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步
· go语言实现终端里的倒计时
· 如何编写易于单元测试的代码
· 10年+ .NET Coder 心语,封装的思维:从隐藏、稳定开始理解其本质意义
· .NET Core 中如何实现缓存的预热?
· 从 HTTP 原因短语缺失研究 HTTP/2 和 HTTP/3 的设计差异
· 周边上新:园子的第一款马克杯温暖上架
· Open-Sora 2.0 重磅开源!
· 分享 3 个 .NET 开源的文件压缩处理库,助力快速实现文件压缩解压功能!
· Ollama——大语言模型本地部署的极速利器
· DeepSeek如何颠覆传统软件测试?测试工程师会被淘汰吗?