xlsVersion (Function)

WINDEV, WEBDEV AND WINDEV MOBILE
ONLINE HELP

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.

Note: The Excel version can be known:

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

Versions 16 and later

This function is now available for WINDEV applications in Linux.

This function is now available for WEBDEV sites in Linux.

New in version 16

This function is now available for WINDEV applications in Linux.

This function is now available for WEBDEV sites in Linux.

This function is now available for WINDEV applications in Linux.

This function is now available for WEBDEV sites in Linux.

Example

See additional examples

// 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 occurred. To find out the error details, use xlsMsgError or ErrorInfo associated 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(<Identifier of XLS file>)

<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 occurred. For more details on the error, use xlsMsgError or ErrorInfo with the constant errMessage.

<Identifier of XLS file>: Integer

Identifier of XLS file to handle, returned by xlsOpen.

Remarks

xlsVersion generates an error in the following cases:

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

Component : wd240xls.dll