PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English US
New WINDEV, WEBDEV 24 feature!
  • Converting the XLS file into XLSX (and conversely)
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadApple WatchUniversal Windows 10 AppWindows Mobile
Others
Stored procedures
<xlsDocument variable>.Save (Function)
In french: <Variable xlsDocument>.Sauve
Saves an XLS document. The saved document remains opened. To close it, you must use <xlsDocument variable>.Close.
Versions 16 and later
WINDEVLinux This function is now available for WINDEV applications in Linux.
WEBDEV - Server codeLinux This function is now available for WEBDEV sites in Linux.
New in version 16
WINDEVLinux This function is now available for WINDEV applications in Linux.
WEBDEV - Server codeLinux This function is now available for WEBDEV sites in Linux.
WINDEVLinux This function is now available for WINDEV applications in Linux.
WEBDEV - Server codeLinux This function is now available for WEBDEV sites in Linux.
Example
MyWorksheet is xlsDocument
FileName is string
FileName = fSelect(fExeDir(), "", ...
"Select a file...", ...
"All files (*.*)" + TAB + "*.*", "*", fselOpen + fselExist)
IF FileName = "" THEN RETURN
MyWorksheet = xlsOpen(FileName, xlsWrite)
 
// Write OK in the A25 cell
MyWorksheet[25,"A"] = "OK"
// Save
MyWorksheet.Save()
 
Syntax
<Result> = <XLS document>.Save([<File path> [, <Password>]])
<Result>: Boolean
  • True if the backup was performed,
  • False otherwise.
<XLS document>: xlsDocument variable
Name of xlsDocument variable to use.
<File path>: Optional character string
Full path and name of the XLS file.

If this parameter is specified, the file is saved at the specified location (the existing file is overwritten if necessary).
  • If the backup is successful, the ..File property of the xlsDocument variable used contains <File path>. The XLS file remains opened.
  • IF the XLS document is saved with a path that differs from the initial one (corresponds to "Save as"), the source file is closed, the document is saved in the new file and the new XLS file remains opened.
If this parameter is not specified, the path taken into account is the path specified in the ..File property of the xlsDocument variable used.
<Password>: Optional character string (with quotes)
Password to use to protect the XLS file at opening. This password must be entered to open the XLS file.
Remarks

Converting the XLS file into XLSX (and conversely)

To convert an XLS file into XLSX (and conversely), all you have to do is modify the extension in <File Path>.
Caution: The conversion loses the merging of the cells, the charts, the drawings, ...
Component : wd240xls.dll
Minimum required version
  • Version 24
This page is also available for…
Comments
Click [Add] to post a comment