ONLINE HELP WINDEV, WEBDEV AND WINDEV MOBILE
Name of the xlsDocument variable corresponding to the XLS file. This variable can be used by all the XLS functions. Using this type of variable allows you to modify the XLS documents.
Result compatible with version 12. For compatibility reasons, this variable can be converted to an integer corresponding to the specified XLS file ID. This ID can be used in all XLS functions that support the file ID. This syntax only allows you to read XLS documents: no modification is possible.
In an error occurs, the ErrorOccurred variable is set to True and ErrorInfo returns the details of the error.
Full or relative path of XLS file to open (up to 260 characters).
Indicates the opening mode of XLS file. By default: the Excel file is opened in read-only mode. You can write to the Excel file with another application. the Excel file uses the multi-sheet management mode for XLS files.xlsCompatibleUsed to open the Excel file in mode compatible with version 10. In this mode: A single workbook sheet is supported. Unicode is not supported. The groups of strings are not supported. Some functions (xlsData or xlsNbRow for example) may return inconsistent results.
From version 11, this constant is available for backward compatibility.
xlsWriteOpens the Excel file in "Read/Write" mode: the XLS file is opened and locked until it is closed. Caution: the modifications performed in the XLS file will be taken into account only if you are using an xlsDocument variable.
Versions 24 and laterPassword to open the XLS file to use. New in version 24Password to open the XLS file to use. Password to open the XLS file to use.
Using the XLS functions in read/write
The XLS file cannot be opened
Last update: 05/26/2022
Send a report | Local help
I accept the terms of the license agreement
All you have to do is configure your product as follows: