Setting the Excel Version Number

How to:

Set the Excel Version in the NLS Configuration File
Set the Excel Version in a Report Request

When using the EXL2K PIVOT format with international versions of Excel, you can set the EXCELRELEASE parameter in the edasprof.prf or nlscfg.err files, or in the procedure itself, to distinguish the version of the user Excel application. If you do not know which version of Excel the users have, you can add EXCELRELEASE as an amper variable within the procedure so that the users are prompted to select their version of Excel. The EXL2KLANG parameter must also be set to the same language as the user version of Excel.

Syntax: How to Set the Excel Version in the NLS Configuration File

EXCELRELEASE = release

where:

release: Is the version of the user Excel application. Values can be: 2000, 2002, or 2003.

Syntax: How to Set the Excel Version in a Report Request

To set the version of Excel in a report request, use the following syntax:

TABLE FILE data_source_name 
. . .
ON TABLE SET EXCELRELEASE release 
. . .
END

where:

data_source_name: Is the name of the data source being reported against.
release: Is the version of the user Excel application. Values can be: 2000, 2002, or 2003.

Example: Setting the Excel Version in a Report Request

The following report request against the CAR database sets the Excel version to Excel 2003:

TABLE FILE CAR
PRINT DEALER_COST
BY CAR
ON TABLE SET EXCELRELEASE 2003 
ON TABLE PCHOLD FORMAT EXL2K PIVOT
END

	WebFOCUS