PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English US
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadApple WatchUniversal Windows 10 AppWindows Mobile
Others
Stored procedures
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
WINDEVLinux This function is now available for the WINDEV applications in Linux.
WEBDEV - Server codeLinux This function is now available for the WEBDEV sites in Linux.
New in version 16
WINDEVLinux This function is now available for the WINDEV applications in Linux.
WEBDEV - Server codeLinux This function is now available for the WEBDEV sites in Linux.
WINDEVLinux This function is now available for the WINDEV applications in Linux.
WEBDEV - Server codeLinux This function is now available for the WEBDEV sites in Linux.
// 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 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. To find out the error details, use xlsMsgError or ErrorInfo associated with the errMessage constant.
<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.
Components
WINDEVWEBDEV - Server codeReports and Queries wd230xls.dll
Linux wd230xls.so
Minimum required version
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment