ONLINE HELP WINDEV, WEBDEV AND WINDEV MOBILE
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.
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.
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: 12/09/2021
Send a report | Local help
I accept the terms of the license agreement
All you have to do is configure your product as follows: