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 Edit dept_LOV Workbook

  1. If not already open, go back in JDeveloper, double click EditDept_LOV_src.xlsx to open it in Excel.

    Application Navigator

  2. In Excel click Workbook Properties in the Oracle ADF tab to open the Edit Workbook Properties dialog.

    Workbook and WebPagesFolder Properties

    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.

    Workbook and WebPagesFolder Properties

    Click OK and OK again.

    Then, Save your work

    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.

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


    Create Excel dialog

    Published workbooks can be stored under public_html if you want them to be accessible from web pages.

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

    Oracle ADF tab of the Excel ribbon

  4. 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.

    Publish Workbook dialog

  5. Type excel as the name of the folder, then click the Open button.

    Publish Workbook dialog

  6. Type EditDept_LOV as the file name and click Save.

    Publish Workbook dialog
    7. 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. It was pointed out earlier in this tutorial that it is good practice to reserve the more meaningful name for the published version.

  7. A message displays, saying the publish operation has been successful.

    Publish Workbook success

  8. Close the Edit dept_LOV workbook.
    The tutorial is complete.

 

Summary
In this tutorial you learned how to use JDeveloper and Oracle ADF Desktop Integration 12c 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:
Previous 1 2 3 4 Next

 


Bookmark Print Expand all | Hide all
Back to top
Copyright © 2014, Oracle and/or its affiliates. All rights reserved.