|
|
|
|
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.
// 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.
This page is also available for…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|