Setting Column Width for Excel in the NLS Configuration File

How to:

Set Column Width for Excel in the NLS Configuration File

The EXL2K_DEFCOLW parameter in the NLS configuration file tells WebFOCUS the value to use to format the output returned to Excel. It is a fixed value for each language.

WebFOCUS automatically uses the correct value for certain languages, and you do not need to do anything:

For English, Finnish, Japanese, Polish, Simplified Chinese, and Traditional Chinese, WebFOCUS uses the correct value of 8 (the default).
For French, German, Norwegian, and Spanish, WebFOCUS uses the correct value of 10.

If you are using a language for Excel other than one mentioned here and you experience a problem with Excel pivot tables or column width, contact your Information Builders representative.

Syntax: How to Set Column Width for Excel in the NLS Configuration File

EXL2K_DEFCOLW = nn|8

where:

nn: Is the column width for Excel. 8 is the default value.