xlsVersion (Function)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

xlsVersion (Function)

In french: xlsVersion

Returns the Excel version that was used to save the file. The latest version number is returned if several versions have been used.

Remark: The Excel version can be known:

if the Excel file exists.
if the Excel file is opened.

Example

// Open an XLS file
XLSFileID = xlsOpen("C:\MyDirectory\File.XLS")
...
// Excel version
ResVersion = xlsVersion(XLSFileID)

Syntax

Syntax that is using the xlsDocument type Hide the details

<Result> = xlsVersion(<XLS document>)

<Result>: Integer

Excel vesion (3, 4, 5, 8), 100 for the XLSX files. The latest version number is returned if several versions have been used.
0 if an error occurs. To get more details on the error, use xlsMsgError or ErrorInfo with the errMessage constant.

<XLS document>: xlsDocument variable

Name of the xlsDocument variable corresponding to the XLS file to use.

Syntax kept for backward compatibility with version 12 Hide the details

<Result> = xlsVersion(<XLS file identifier>)

<Result>: Integer

Excel vesion (3, 4, 5, 8), 100 for the XLSX files. The latest version number is returned if several versions have been used.
0 if an error occurs. To get more details on the error, use xlsMsgError or ErrorInfo with the errMessage constant.

<XLS file identifier>: Integer

Identifier of the XLS file to handle, returned by xlsOpen.

Remarks

xlsVersion throws an error in the following cases:

the specified XLS file is not opened.
the Excel version in unknown.

Component: wd280xls.dll