Part 4: Publishing the Workbooks
In this tutorial you have developed two desktop integration-enabled workbooks. In this final part you publish them.
Step 1: Publish the DepartmentsList Workbook
  1. Back in JDeveloper, double click DepartmentsList_src.xlsx to open it in Excel.

    alt text
  2. In Excel click Workbook Properties and check that the value in the ApplicationHomeFolder field identifies the location of the application. Then click the more button in the WebPagesFolder field and navigate to the public_html folder to specify where the published workbooks will be stored. Note that if you have not set a value for the WebPagesFolder property, you will be prompted to set one when you attempt to publish the workbook.

    Click OK and OK again.

  3. It is recommended that you keep your "source" and "published" workbooks in separate locations. The integrated "source" workbooks are stored in the source directory in the workspace. Show more or lessRead more...

    When you created your workbook from the New Gallery in an earlier step, the wizard directed you to save it under src\excel.


    show

    Published workbooks can be stored under public_html if you want them to be accessible from web pages.
  4. In the Oracle ADF tab of the Excel ribbon, click Publish.

    alt text
  5. The Publish Workbook dialog displays. Navigate to the public_html folder and then click the Create New Folder icon to create a location for your published workbooks.

    alt text
  6. Type excel as the name of the folder, then click the Open button.

    alt text
  7. Type DepartmentsList as the file name and click Save.

    alt text
  8. The name you provide here for the published workbook must be different from the name of the source file. Otherwise it will cause an Excel error. Show more or lessRead more... It was pointed out earlier in this tutorial that it is good practice to reserve the more meaningful name for the published version.
  9. A message displays, saying the publish operation has been successful.

    alt text
  10. Close the DepartmentsList workbook and follow the steps below to publish the EditDept_LOV workbook.

Step 2: Publishing the EditDept_LOV Workbook

The steps for publishing the EditDept_LOV workbook are basically the same as for publishing the DepartmentsList workbook.

  1. Open EditDept_LOV_src.xlsx in Excel, and click Workbook Properties to open the dialog.

  2. Click the more button in the WebPagesFolder field and navigate to the public_html folder as before, to specify the location of the published workbooks.

    Click OK and OK again.

  3. In the Oracle ADF tab of the Excel ribbon, click Publish.

  4. In the excel folder under public_html, type EditDept_LOV as the file name and click Save.

  5. As before, a message displays, saying the publish operation has been successful.

  6. Exit from Excel. Your workbooks are now published and are ready to be deployed with your application to the WebLogic server.

Summary
In this tutorial you learnt how to use JDeveloper and Oracle ADF 11g Desktop Integration to develop Excel workbooks that are integrated with an ADF Web application. You learned how to: To learn more about ADF desktop integration, refer to:

Bookmark Print Expand all | Hide all
Back to top

Did you find this page helpful?



Copyright © 2011, Oracle. All rights reserved.