WINDEV, WEBDEV AND WINDEV MOBILEONLINE HELP
True if the file was loaded in the Spreadsheet control,False otherwise.
Name of Spreadsheet control used.
Name and full path of file (in XLSX format) to load.Caution: You cannot load an XLSX file containing more than 2 millions cells.
Number of the worksheet to load. -1 to use the default behavior: If the Spreadsheet control is in multi-worksheet mode, all the worksheets will be loaded.If the Spreadsheet control is not in multi-worksheet mode, only the first worksheet will be loaded. Remark: Before version 200057, if this parameter is not specified, the first worksheet of the file is loaded (no management is available for the different worksheets).
Mode for opening the XLSX file to load: psheetLoadDefault(Default value)The XLSX file loaded in the Spreadsheet control is opened in write mode. In this mode, to open the ".xlxs" file with another application, it must be closed by SpreadsheetClose.psheetLoadUnlinkedThe XLSX file loaded in the Spreadsheet control is loaded in memory only. The ".xlxs" file can be opened by another application. To save the modified data, you must use SpreadsheetSave associated with the psheetOverwriteAllowed constant. In this case, the data modified by another application will be overwritten. Versions 24 and laterpsheetLoadKeepPasswordNew in version 24psheetLoadKeepPasswordpsheetLoadKeepPasswordThe password of the XLSX file loaded in the Spreadsheet control is kept in memory. When saving the file ("Save as" or SpreadsheetSave), it will not be necessesary to specify the file password again.. The password will be kept. Remark: This parameter is available from version 200057.
Versions 24 and laterPassword to open the XLSX file to use (if the file is protected by a password). New in version 24Password to open the XLSX file to use (if the file is protected by a password). Password to open the XLSX file to use (if the file is protected by a password).
Last update: 04/28/2020
Send a report | Local help
J'accepte les termes de la licence
All you have to do is configure your product as follows: