PC SOFT

ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Home | Sign in | English EN
This content has been translated automatically. Click here to view the French version.
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac CatalystUniversal Windows 10 App
Others
Stored procedures
Saves the content of a Spreadsheet control in a file in XLSX format.
Example
// Sauvegarde du fichier en cours
SpreadsheetSave(TBLR_Tableur, "Classeur1.XLSX")
// Chargement du fichier
SpreadsheetLoad(TBLR_SansNom1, "test.xlsx")
// Modification du fichier
TBLR_SansNom1["A","1"] = "modifié"
// Sauvegarde sous un autre nom
// Le fichier "text1.xlsx" existe déjà
IF SpreadsheetSave(TBLR_SansNom1, "test1.xlsx") = False THEN
// Avant la version 200051, le fichier xlsx existant est écrasé.
// A partir de la version 200051, le fichier xlsx existant n'est pas modifié.
// La fonction renvoie Faux et une erreur
// Pour écraser le fichier, utilisez la constante tblrEcrasementAutorisé
Error("Fichier non sauvegardé " + ErrorInfo()
ELSE
Info("Fichier sauvegardé")
END
Syntax
<Result> = SpreadsheetSave(<Spreadsheet control> , <File to save> [, <Option> [, <Password>]])
<Result>: Boolean
  • True if the file of Spreadsheet control was saved,
  • False otherwise. ErrorInfo returns more details about the error.
<Spreadsheet control>: Control name
Name of the Spreadsheet control to be used.
<File to save>: Character string (with quotes)
Name and full path of XLSX file where the content of Spreadsheet control will be saved.
<Option>: Optional Integer constant
File save mode if the file already exists:
0 (or nothing)
(Default behavior)
If the XLSX file already exists and is not open (in Spreadsheet control or another application), it is not saved.
psheetOverwriteAllowedIf the XLSX file already exists and is not opened (in the Spreadsheet control or another application), it is overwritten.
<Password>: Optional character string (with quotes)
Versions 24 and later
Password to use to protect the XLSX file at opening. This password must be specified to open the XLSX file.
New in version 24
Password to use to protect the XLSX file at opening. This password must be specified to open the XLSX file.
Password to use to protect the XLSX file at opening. This password must be specified to open the XLSX file.
Remarks
  • To open the ".xlxs" file saved with another application, it must be closed by SpreadsheetClose.
  • The saved file can be reloaded in a Spreadsheet control via SpreadsheetLoad and xlsOpen.
  • This function can only be used on a Spreadsheet control found in a window.
  • Versions 23 and later
    SpreadsheetSave updates the FilePath property of Spreadsheet control by associating the name of loaded file to the Spreadsheet control.
    New in version 23
    SpreadsheetSave updates the FilePath property of Spreadsheet control by associating the name of loaded file to the Spreadsheet control.
    SpreadsheetSave updates the FilePath property of Spreadsheet control by associating the name of loaded file to the Spreadsheet control.
Related Examples:
The Spreadsheet control Unit examples (WINDEV): The Spreadsheet control
[ + ] Using the Spreadsheet control.
This example explains how to:
- load an xlsx file in a spreadsheet control,
- save the spreadsheet in a file,
- fill the control with data coming from the database,
- insert rows, columns,
- access the cells and handle them (modify their value, their style, ...),
- enter formulas,
- ...
Business / UI classification: UI Code
Component: wd270obj.dll
Minimum version required
  • Version 20
This page is also available for…
Comments
Click [Add] to post a comment