You can create integrated Excel workbooks for your internationalized Fusion web application. Designing your integrated Excel workbook as part of the internationalized Fusion web application helps in its easy adaptation to specific local languages and cultures. Using resource bundles, you can configure your integrated Excel workbook for a specific local language or culture by providing translations of the user-visible strings that appear to end users at runtime. See Localization in ADF Desktop Integration.

Figure 11-1 shows an example of an integrated Excel workbook configured for the Japanese language.

After you have internationalized your integrated Excel workbook, you may find that you need to add additional functionality to configure your workbook. The following sections describe other functionality that you can use:

• Security: Whether you are using a secure Fusion web application or not, you must be aware of security implementations in your integrated Excel workbook. See Securing Your Integrated Excel Workbook.

• Validating integrated Excel workbook: You can configure server-side and client-side data entry validation for the Fusion web application and the integrated Excel workbook. See Adding Validation to Your Integrated Excel Workbook .

• Publishing and deploying integrated Excel workbook: The final step after you design and validate your integrated Excel workbook is to publish and deploy it. See Deploying Your Integrated Excel Workbook .

1. Open the integrated Excel workbook.
2. In the Workbook group of the Oracle ADF tab, click Workbook Properties.
3. In the Edit Workbook Properties dialog, click the browse (...) icon beside the input field for Resources to display the Edit Resources dialog shown in Figure 11-2.

   Figure 11-2 Edit Resources Dialog

   
4. Specify values for the resource bundle and then click OK.

   For information about the values to specify for a resource bundle, see the entry for Resources in Table A-19.

See the following sections for additional information about resource bundles in an integrated Excel workbook.

Resource Bundle Types

ADF Desktop Integration supports use of the following types of resource bundle:

• Properties bundle (.properties)

• List resource bundle (.rts)

• Xliff resource bundle (.xlf)

For information about resource bundles, see Manually Defining Resource Bundles and Locales in Developing Web User Interfaces with Oracle ADF Faces.

Caching of Resource Bundles in an Integrated Excel Workbook

ADF Desktop Integration caches the values of string keys from the resource bundles that an integrated Excel workbook retrieves when it first connects to the Fusion web application. If you change a string key value in a resource bundle after an integrated Excel workbook has cached the previous value, the modified value does not appear in the workbook unless the ClearAllData workbook action is invoked and the end user closes and reopens the workbook so that it retrieves the modified value from the Fusion web application. For information about the ClearAllData workbook action, see Table A-18.

EL Expression Syntax for Resource Bundles

ADF Desktop Integration requires that you enclose the string key name in EL expressions using the [] characters, as in the following example:

#{res['StringKey']}

Note that ADF Desktop Integration does not support the following syntax:

#{res.StringKey}

The server-side localization comprises of ADF Desktop Integration server resources and Application Custom Resources. By default, ADF Desktop Integration uses the client-side Internet Explorer's language preference to determine server-side localization, but you can configure the Fusion web application to determine the server-side locale. To do that, you would need to create a user preference handler and register it by adding a UserPreferences.Handler initialization parameter for ADF Desktop Integration servlet.

public class CustomUserPrefsHandler 
{
  public Locale getLocale ()
  {
    UserPref info = (UserPref) 
           ADFContext.getCurrent().getSessionScope().map.get("User_Pref_Info");
    return info.getLocale();
  }
}

<servlet>
  <servlet-name>adfdiRemote</servlet-name>
  <servlet-class>
    oracle.adf.desktopintegration.servlet.DIRemoteServlet
  </servlet-class>
  <init-param>
    <param-name>UserPreferences.Handler</param-name>
    <param-value>myCompany.XYZ.CustomUserPrefsHandler</param-value>
  </init-param>
</servlet>