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.
Consider running the Client Health Check to determine if your environment is configured correctly after you run the ADF Desktop Integration installer. For more information, see Running the Client Health Check Tool.
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.5.2 provides the runtime and associated files required to run applications developed to target the Microsoft .NET Framework. You can download the framework from
Microsoft .NET Framework 4.5.2 is the minimum required version. ADF Desktop Integration is also compatible with Microsoft .NET Framework 4.6.
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 How to Install the ADF Desktop Integration Add-in From a Web Server.
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 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.
Note the following points about installation:
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. If you do not select the Enabled option, the Oracle ADF tab shown in Figure 3-1 does not appear in Microsoft Excel.
Figure 3-1 Oracle ADF Tab in Microsoft Excel
Designer features are automatically enabled if you install ADF Desktop Integration from JDeveloper.
You can also install ADF Desktop Integration from the command line.
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.
When you test your integrated Excel workbooks, ADF Desktop Integration may prompt you with a dialog to install the add-in version that your test server uses. Although this dialog contains an option to skip, you, as a developer, should never skip the installation of the add-in version that the dialog proposes. It is important to keep the version of the add-in that the client uses synchronized with the ADF Desktop Integration servlet version.