This chapter includes the following sections:
Setting up the development environment involves making sure that you have the correct versions of JDeveloper and Microsoft Office installed, as described in Required Oracle ADF Modules and Third-Party Software.
After verifying that you have the required software, complete the setup of your development environment by:
Configuring Microsoft Excel to work with ADF Desktop Integration
Installing ADF Desktop Integration
The instructions in this guide assume that you are using Windows 7 operating system and Microsoft Excel 2007. Note that the steps might be different for different editions of Windows and Excel.
Before you begin to integrate your Excel workbook with a Fusion web application, ensure that you have the required Oracle ADF modules and third-party software installed and configured:
Install the current release of JDeveloper. ADF Desktop Integration is available as a JDeveloper feature.
Microsoft Windows operating systems support the development and deployment of Excel workbooks that integrate with Fusion web applications. For more information about supported versions of Windows, click the "Certification Information" link for this release on the following OTN page:
ADF Desktop Integration supports the integration of Fusion web applications with the following types of Excel workbook:
The default file format for Excel workbooks is the Excel XML-based file format (
Excel Macro-Enabled Workbook
Workbooks in this format (
.xlsm) use the Excel XML-based file format and can store VBA macro code.
ADF Desktop Integration does not support the use of other Excel file formats. For more information about supported versions of Excel, click the "Certification Information" link for this release on the following OTN page:
Some features in ADF Desktop Integration use a web browser control from the Microsoft .NET Framework. This browser control relies on the local Internet Explorer installation to function properly.
ADF Desktop Integration uses Internet Explorer to render web pages inside Excel, regardless of other browsers installed on the system or any other browser set as the default browser.
You need to perform the following procedure once if you plan to use ADF Button components in your integrated Excel workbook.
Due to technical limitations with ADF Button components, we recommend that you use worksheet-level ribbon commands instead of ADF Button components. For more information about these limitations, see Inserting an ADF Button Component.
To allow Excel to run an integrated Excel workbook:
Figure 3-1 Excel Trust Center Dialog
When you run the ADF Desktop Integration installer, it verifies whether software in the following list is installed on the system where you want to install the add-in. If one or more of these pieces of software is not installed, the installer automatically downloads and installs it in the order specified.
The Microsoft .NET Framework 4 provides the runtime and associated files required to run applications developed to target the Microsoft .NET Framework. You can download the framework from
Do not download the Client Profile edition of Microsoft .NET Framework as it is insufficient to run ADF Desktop Integration.
Installation of Microsoft .NET Framework may require you to restart the system where you install it. After the restart, the installer automatically recommences to finalize installation.
The Microsoft Visual Studio 2010 Tools for Office Runtime (version 4) is required to run VSTO solutions for the Microsoft Office system. You can download the Microsoft Visual Studio 2010 Tools for Office Runtime from
You can install the ADF Desktop Integration add-in from JDeveloper, or from the adfdi-excel-addin-installer.exe installer available in the following directory:
For more information about how to set up ADF Desktop Integration, see How to Install ADF Desktop Integration. You can also install it from an ADF Desktop Integration-enabled Fusion web application. For more information, see the "How to Install the ADF Desktop Integration Add-in From a Web Server" section in Administering Oracle ADF Applications.
Note that the ADF Desktop Integration installation is specific to the current Windows user profile. If you have multiple Windows user profiles on your system, and you want to use ADF Desktop Integration integrated Excel workbooks from some specific user profiles, you must log in to each user profile and install the ADF Desktop Integration add-in. For more information, see How to Install ADF Desktop Integration.
You can install the ADF Desktop Integration add-in from JDeveloper, and then create and test integrated Excel workbooks.
Although you do not require administrator privileges to install the ADF Desktop Integration add-in, administrator privileges may be required to run the installer for additional software that the installer attempts to download and install. You should also ensure that the proxy settings for Internet Explorer are configured to allow access to
*.microsoft.com because the installer attempts to automatically download missing prerequisite software from the Microsoft's website.
Before you begin:
It may be helpful to have an understanding of ADF Desktop Integration requirements. For more information, see Installing ADF Desktop Integration.
To install ADF Desktop Integration:
The Install ADF Desktop Integration menu option is available only on the Windows installation of JDeveloper.
Follow the instructions that appear in the dialog boxes to successfully install the required components. If you encounter an error during the installation process, an error message with a description appears, and installation is rolled back. For more details, check the
adfdi-installer-log.txt error log file in the
temp directory of the user profile.
You can also install ADF Desktop Integration by running
adfdi-excel-addin-installer.exe available in the following directory:
Before you run the installer, remember that the ADF Desktop Integration add-in installer does not enable designer features by default. You must enable the designer features in the add-in to create and edit integrated Excel workbooks.
In the ADF Desktop Integration Installer page of the wizard, click Developer Options, and then in the Developer Options page select the Enabled option, and click Install.
Designer features are automatically enabled if you install ADF Desktop Integration from JDeveloper.
You can also install ADF Desktop Integration from the command line.
The ADF Desktop Integration files are installed in the
\Oracle\Oracle ADF Desktop Integration 12c Add-In for Excel subdirectory of the system-defined
Local App Data directory (For example,
C:\Users\johndoe\AppData\Local\Oracle\Oracle ADF Desktop Integration 12c Add-In for Excel).
If you want to install ADF Desktop Integration for end users, see Installing, Upgrading, and Removing ADF Desktop Integration.
Use the Microsoft Windows Control Panel to remove the ADF Desktop Integration add-in from the system where you set it up. After removing ADF Desktop Integration, you can no longer use integrated Excel workbooks on this system unless you reinstall ADF Desktop Integration.
To remove the ADF Desktop Integration add-in:
If you have installed ADF Desktop Integration on multiple user profiles, you must remove it from each user profile.
To upgrade to a new version, run the ADF Desktop Integration installer from the new version. It is not necessary to uninstall the old version first.
You can run the installer from:
JDeveloper Tools menu
Welcome page of the running Fusion web application (see Verifying That Your Fusion Web Application Supports ADF Desktop Integration )
File system (see the Notes section of How to Install ADF Desktop Integration)
If you are upgrading from a previous release, you may receive a message that says that ADF Desktop Integration was installed with an incompatible installer. In this case, you must uninstall the ADF Desktop Integration add-in prior to running the installer.