Setting the Language of Excel in the NLS Configuration File

How to:

Set the Language of Excel in the NLS Configuration File

The WebFOCUS Reporting Server needs to know the language of Excel running on the computer of the end user in order to correctly format output returned to Excel. You specify the language on the EXL2KLANG parameter in the NLS configuration file (nlscfg.err).

You can also code the SET EXL2KLANG command in a server profile or user profile, or in a procedure, to override the setting in the NLS configuration file.

Syntax: How to Set the Language of Excel in the NLS Configuration File

EXL2KLANG = {language|ENG}

where:

language

Is the language of Excel. Possible values are:

ENG for English. ENG is the default value.
FIN for Finnish.
FRE for French.
GER for German.
JPN for Japanese.
NOR for Norwegian.
POL for Polish.
PRC for Simplified Chinese.
SPA for Spanish.
ROC for Traditional Chinese.

Example: Controlling Numeric Format in Excel Through Regional Options

In this example, a WebFOCUS report request accesses a data source that contains numbers stored in English (United States) format. The user has set Regional Options on Windows to the locale German (Germany).

The report output displays in an Excel spreadsheet, as shown in the following image. The numbers are formatted according to the convention of the German locale: