ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / WLanguage / WLanguage functions / Standard functions / XLS file functions
  • Converting the XLS file into XLSX and vice versa
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 an XLS/XLSX document. The saved document remains open. To close it, you must use xlsClose.
New in version SaaS
Android This function is now available for Android applications.
Android Widget This function is now available in Android widget mode.
iPhone/iPad This function is now available for iPhone/iPad applications.
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
xlsSave(MyWorksheet)
Syntax
<Result> = xlsSave(<XLS document> [, <File path> [, <Password>]])
<Result>: Boolean
  • True if saved successfully,
  • False otherwise.
<XLS document>: xlsDocument variable
Name of the variable of type xlsDocument to be used.
<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 file is saved successfully, the File property of the xlsDocument variable 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 specified in the File property of the xlsDocument variable will be used.
<Password>: Optional character string
Password to use to protect the XLS file at opening. This password must be specified to open the XLS file.
Remarks

Converting the XLS file into XLSX and vice versa

To convert an XLS file into XLSX and vice versa, 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: wd300xls.dll
Minimum version required
  • Version 14
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 06/06/2024

Send a report | Local help